Hi,

I have a MEMO field that contains plain text information.
I would like to show the first 4000 characters of it in my query.

for example :

SELECT CAST( substring( RDB$VIEW_SOURCE from 1 for 4000) as varchar
(4000) ) as VIEW_CODE
FROM RDB$RELATIONS R
where (RDB$SYSTEM_FLAG=0) and
(RDB$VIEW_SOURCE is not null)

gives me the following error :
conversion error from string "BLOB"

Clément