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