carriage return?

[js]

hi, how to put a
carriage return into a update query:

update tb1 set fd1 = "" + chr(13) + ""??



thanks.

 

[Douglas J. Steele]

You need both Chr(13) & Chr(10) in that order, and you really don't need the
null strings.

update tb1 set fd1 = chr(13) & chr(10)

Of course, I don't see what use fd1 is going to be!