SQL question CRLF

[Ruslan Zasukhin]

On 7/14/05 2:33 AM, "Damon Pillinger" <daisychain at iinet.net.au> wrote:

> Hi Ruslan and serge.
> 
> Don't worry I figured it out
> 
> UPDATE [table] SET field_name = "line1<crlf>line2"
> 
> Replace <crlf> with chr(13) only and it works fine.

Hi Damon,

Ok, in any case Segey will add feature

    SET fld = 'line\rline2'

Also will be supported \n, \t, \b, ...


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]