Subject Carriage return in SQL Script
Author Todd Brasseur
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