COnverting LONG to CHAR

From: Stephen Schow <sjs_at_netcom.com>
Date: 3 Nov 92 19:44:38 GMT
Message-ID: <1992Nov3.194438.20420_at_netcom.com>


Anyone know how to return a LONG datatype as a CHAR. I want to create a view of a table that contains a LONG datatype, but I want the LONG to appear as a CHAR in the view(obviously it will be truncated). I can't figure out how to do it. Anyone know?

-- 

------------------------------------------------------------------
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...... | Have I given you a clue......? | - Baloo the Bear
------------------------------------------------------------------
Received on Tue Nov 03 1992 - 20:44:38 CET

Original text of this message