I think that this works also:

declare variable varCRLF char(2);

varCRLF = '
';

I know, it looks crazy, but I think it works.

-steve

On Thu, 2005-10-13 at 11:20 -0600, Todd Brasseur wrote:

> I found a UDF that does this:
>
> update propertyheader
> set printednotes = 'test'||f_crlf()||'test2'
> where roll = '1032837'
>
> Todd
>
> *****************************************************
>
> Is it possible to update a 'memo' field with text including carriage
> return line feeds in a script?
>
> Something like:
>
> update tablename
> set memofield = 'First Line'||CRlf||'Second Line';
> where field = ''XYZ'
>
> Todd
>
>
>
>
> ------------------------ Yahoo! Groups Sponsor
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
>


[Non-text portions of this message have been removed]