Subject Carriage return in SQL Script - Figured it out
Author Todd Brasseur
I found a UDF that does this:

update propertyheader
set printednotes = 'test'||f_crlf()||'test2'
where roll = '1032837'



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'