converting CLOB into VARCHAR2?

Hi folks,

        After doing a few max(dbms_lob.getlength())s on our CLOB fields, we've discovered that there are quite a few that should be VARCHAR2(4000) instead . What would be the best way to convert them? Is there a way that gets around using DBMS_LOB.READ? How should I compare a CLOB and a VARCHAR2?

        Thanks for any help you can give!

		Yours Truly,
		Jeffrey Boulier

-- 
 _ __ _ _ ___ _ __  ___| |_| |_  ___ _  _ ___ Senior Programmer/Analyst
| '_ \ '_/ _ \ '  \/ -_)  _| ' \/ -_) || (_-<    www.prometheus.com
| .__/_| \___/_|_|_\___|\__|_||_\___|\_,_/__/ George Washington University
|_|