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