On Mon, 03 Sep 2012 07:00:18 -0000, "sir_wally_lewis"
<rgilland1966@...> wrote:

> Hi,
>
> I have a problem, where I need to use SQL to update a Memo field.
> The textual data includes carriage returns.
>
> This should be simple however the below fails:
>
> UPDATE ST_SCLE_PRNT_FMT
> SET NA_SCLE_PRNT_FRMT = '[2|02:*]' || #13#10 || 'BARFMTDEFAULT=00' ||
> #13#10 ||
> 'USEDATE=SELLDATE' || #13#10 || 'CSYMBOL00=0' || #13#10 || 'CSYMBOL01=1'
> || #13#10 ||
> 'CSYMBOL02=2' || #13#10 || 'CSYMBOL06=4' || #13#10 || 'CSYMBOLDEFAULT=1'
> || #13#10 ||
> 'C01=B0,C6,D|27' || #13#10 || 'C02=B0,E6,F|27' || #13#10 ||
> 'I01=B1,C2,D|55' || #13#10 ||
> 'I02=B1,E2,F|55' || #13#10 || 'I03=B1,G2,H|55' || #13#10 ||
> 'I04=B2,C2,D|55'
> WHERE( ID_SCLE_PRNT_FRMT = 50 )
>
> with error
>
> Dynamic SQL Error SQL error code = -104 Token unknown - line 2, column

39 #

>
> how can I solve this?

Use the built-in function ASCII_CHAR:
http://www.firebirdsql.org/refdocs/langrefupd25-intfunc-ascii_char.html

Mark