Subject Re: [firebird-support] Carriage return in SQL Script - Figured it out
Author Thomas Steinmaurer
Hi Todd,

> I found a UDF that does this:
> update propertyheader
> set printednotes = 'test'||f_crlf()||'test2'
> where roll = '1032837'

You don't need an UDF for that.


update tablename
set memofield = 'First Line
Second Line'
where field = 'XYZ'

Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions