| Subject | Re: [firebird-support] return text BLOB contents from SP | 
|---|---|
| Author | Norbert Nemeth | 
| Post date | 2005-07-29T20:32:40Z | 
Hi Rick,
SELECT SUBSTRING(MEMO_CUST FROM 1 FOR 2048)
FROM ORDERS WHERE INVOICENUM = :INVOICENUM
Regards,
Norbert
            > declare variable CustMemo VarChar(2048);Try that:
> ...
> Select MEMO_CUST from ORDERS where INVOICENUM = :INVOICENUM
> into :CustMemo;
SELECT SUBSTRING(MEMO_CUST FROM 1 FOR 2048)
FROM ORDERS WHERE INVOICENUM = :INVOICENUM
Regards,
Norbert