Re: How do I read the contents of a LONG field?

Try using PL/SQL. Char datatypes can be up to 2000 characters long now and you can load LONG's into CHAR variables. Once there, you can substr() all you want.

BTW - IMHO - LONG's are bad, nasty , little things that should always be avoided!!!!

-- 


------------------------------------------------------------------

Steve Schow    | But you don't have to use the claw, if you
sjs_at_netcom.com | pick the pear with the big paw paw......
(415) 354-4908 | Have I given you a clue......?
               |                       - Baloo the Bear


------------------------------------------------------------------