Of course it will.... Thanks... :) BTJ
On Fri, 2003-08-22 at 19:47, David Olbersen wrote: > 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. ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly