Re: Inserting CR/LF in a select?

Bjørn T Johansen muttered:

> I need to get two fields from two tables and append them into one field
> with CR/LF in between, how is this done using a select?

I believe something along the lines of:

  SELECT column1||'\r\n'||column1 FROM table;

will do the trick.

--
David Olbersen
iGuard Engineer
St. Bernard Software
11415 West Bernardo Court
San Diego, CA 92127