I have a blob (text) that I need to update with some data from some other
fields. This is a new field in the table, and for historical purposes I need
ot just fill in the data for existing rows. The system will populate new
rows.

I need to embed some EOLs though. So something like

Update "Table" set "NewField" (
select "Name" + EOL + "City" from "Table1" where ...
)

Any idea how I can get an EOL literal in SQL? This is a one time run, so I
don't want to use a UDF, etc.

--
Chad Z. Hower aka Kudzu
"Programming is an art form that fights back"

Still doing your website by hand? Get a free content management system:
http://www.atozed.com/iws/