Hi

I've got this in a different way.
Just put a line break into a string, like this:

select
a.name || '
' || a.description as name
from test a

In my tests here it works fine. :)
Hope it helps.

Regards
Fabio Schunig


Ismael L. Donis García escreveu:

> 1 million thanks
> =========
> ¦¦ ISMAEL ¦¦
> =========
>
> ----- Mensaje original -----
> De: tomkrej
> Para: firebird-support@yahoogroups.com
> Enviado: martes, 20 de octubre de 2009 01:57
> Asunto: [firebird-support] Re: Returns inside a field
>
>
> Try to use UDF ASCII_CHAR(10)
>
> declaration is
>
> DECLARE EXTERNAL FUNCTION ascii_char
> INTEGER
> RETURNS CSTRING(1) FREE_IT
> ENTRY_POINT 'IB_UDF_ascii_char' MODULE_NAME 'ib_udf';
>
> > It is possible to accomplish a consultation that gives back a returns intermediate?
> >
> > Example: select a.name || chr(10) || a.description as name from test a
> >
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org 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
>
>
>
>
>

__________________________________________________
Faça ligações para outros computadores com o novo Yahoo! Messenger
http://br.beta.messenger.yahoo.com/