carriage return?

  • Thread starter Thread starter js
  • Start date Start date
J

js

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

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



thanks.
 
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!
 
Back
Top