Subject Re: [firebird-support] return text BLOB contents from SP
Author Norbert Nemeth
Hi Rick,

> declare variable CustMemo VarChar(2048);
> ...
> Select MEMO_CUST from ORDERS where INVOICENUM = :INVOICENUM
> into :CustMemo;

Try that:
SELECT SUBSTRING(MEMO_CUST FROM 1 FOR 2048)
FROM ORDERS WHERE INVOICENUM = :INVOICENUM

Regards,
Norbert