Maybe

StringA || ASCII_CHAR(13) || StringB

or

StringA || ASCII_CHAR(13) || ASCII_CHAR(10) || StringB

----- Original Message -----
From: "Robert martin" <rob@...>
To: <firebird-support@yahoogroups.com>
Sent: Monday, October 17, 2005 4:57 PM
Subject: [firebird-support] Joining two string fields


> Hi
>
> I want to return StringA || StringB. I can do this fine but would like
> a cr between the two strings so they begin on different lines (when
> printed). How do I do this?
>
> --
> Rob Martin
> Software Engineer
>
> phone +64 03 377 0495
> fax +64 03 377 0496
> web www.chreos.com
>
> Wild Software Ltd
>
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
>