> I would like to prevent UDF.

Funny, you want to avoid a UDF, yet you rely on platform specific
(or even tool specific) behaviour in your script.

Martijn Tonies
Database Workbench - development tool for Firebird and more!
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com

> Thanks,
> Paulo Geloramo
>
> > It is usually a better idea to make the characters explicit. From
> > the Firebird Book, p162:
> >
> > INSERT INTO Table1 (Field1)
> > VALUES ('Line1' || Ascii_Char(13) || Ascii_Char(10) || 'Line2');