| Subject | Re: return text BLOB contents from SP | 
|---|---|
| Author | Rick Roen | 
| Post date | 2005-07-29T21:42:41Z | 
> Try that:Thanks Norbert, that works.
> SELECT SUBSTRING(MEMO_CUST FROM 1 FOR 2048)
> FROM ORDERS WHERE INVOICENUM = :INVOICENUM
Rick
| Subject | Re: return text BLOB contents from SP | 
|---|---|
| Author | Rick Roen | 
| Post date | 2005-07-29T21:42:41Z | 
> Try that:Thanks Norbert, that works.
> SELECT SUBSTRING(MEMO_CUST FROM 1 FOR 2048)
> FROM ORDERS WHERE INVOICENUM = :INVOICENUM