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.

Try:

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
http://www.upscene.com