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
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
