Maybe record StringA with an appended <CR> in the Table :)

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


> Hi
>
> Will do if I have too but we are trying to avoid using any extra Dlls
> (even the shipped ones), just to avoid potential installation or
> configuration problems.
>
> Rob Martin
> Software Engineer
>
> phone +64 03 377 0495
> fax +64 03 377 0496
> web www.chreos.com
>
> Wild Software Ltd
>
>
>
> Adam wrote:
>
>>--- In firebird-support@yahoogroups.com, Robert martin <rob@c...>
>>wrote:
>>
>>
>>>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 :)
>>>
>>>
>>>
>>
>>It is an add on dll, but the dll ships pre-installed with Firebird.
>>Look in the udf folder, ib_udf.sql "installs" the function into your
>>database.
>>
>>Adam
>>
>>
>>
>>
>>>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@c...>
>>>>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
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>
>>
>>
>>
>>
>>
>>
>>++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>>
>>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
>
>
>
>
>
>
>
>