>I didn't design the DB - I'm just pulling data out of it ;) :-)
For me this
SELECT CAST(VarCharMaxField as varchar(254)) AS VarCharMaxField FROM SomeTable
works. You can not see CRLF chars in normal BROWSE but if you copy the result into CSV table and open it with notepad you will see that these chars are there
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller The only thing normal about database guys is their tables.