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

Reply via email to