Subject Re: [ib-support] SQL questions
Author Ian Newby
Hi,
There is a bug in the SQL definition of the ASCII_CHAR udf function. I
don't remember what the correct definition is, but you can work around
it by using the following:

EOL = SUBSTR(ASCII_CHAR(10),1,1) || SUBSTR(ASCII_CHAR(13),1,1);

I've been using this for months.

Regards,

Ian Newby