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