Subject Re: [firebird-support] Joining two string fields
Author Robert martin
Hi

I assume ASCII_CHAR(13), is a non standard function that is available in
an add on DLL ? I was hoping for something built in :)


Rob Martin
Software Engineer

phone +64 03 377 0495
fax +64 03 377 0496
web www.chreos.com

Wild Software Ltd



Hans wrote:

>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
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>
>
>
>
>
>++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
>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
>
>
>
>
>
>
>
>
>
>
>
>