martinthrelly wrote:

>hi there. i have found a UDF in the FreeUDFLib.dll called
>F_BLOBASPCHAR. this udf allows me to convert a blob to a string. i
>notice that this UDF has a return type of CSTRING(1024).
>
>i need to manipulate this string within a stored procedure. but in
>order to do this i guess i must first assign the returned UDF value to
>a local variable.
>
>but i cant go like this because cstring is not a recognised type o
>dont think:
>declare variable mystring cstring(1024);
>
>

declare variable MyString varchar(1024);

>mystring = F_BLOBASPCHAR(myblob);
>
>also i cant cast the blob as a firebird varchar data type because it
>might be too big for that.
>
>

You can use substring, it converts a blob to varchar

Substring(MyBlob from 1 for 1024)

see you !

--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br