substr of LONG datatype?
From: (wrong string) © <kark_1999_at_yahoo.com>
Date: Wed, 27 Feb 2002 18:54:03 GMT
Message-ID: <fX9f8.29140$%b6.8297006_at_typhoon.ne.ipsvc.net>
Date: Wed, 27 Feb 2002 18:54:03 GMT
Message-ID: <fX9f8.29140$%b6.8297006_at_typhoon.ne.ipsvc.net>
How can I get a SUBSTR of a long?
for example, I'm attempting this...
select substr(comment_txt, 1, 30)
getting an "inconsistent datatype" error.
Any suggestions?
thanks.
Received on Wed Feb 27 2002 - 19:54:03 CET