Subject | RE: [firebird-support] Re: How to add CRLF to VARCHAR column |
---|---|
Author | Alan McDonald |
Post date | 2006-02-01T22:11:21Z |
> Hi Dave,there is another way not mentioned yet,
>
> > Page 898 deals with the ASCII_CHAR function in the IB_UDF library
> > with an example which constructs CRLF.
>
> As I said in my original post I cannot use a UDF (due to additional work
> required in deployment and maintenance of more than a hundred sites).
>
> I might stick with the
>
> CRLF = '
> ';
>
> trick.
>
> Regards,
>
> Jarrod Hollingworth
>
you put the CRLF character in a char field in a table and select it when you
want it.
I use this method when working with external files
Alan