How do you put a carriage return into the field of an SQL statement using VB?

Question

I want to insert a record using SQL and one of the fields needs to contain a carriage return, e.g.

Notes field:

Line 1 
Line 2 
End line

How would I code this SQL statement using VB

Answer 1

When you build the insert statement, you store it in a string somewhere. Add an escaped newline character into the string wherever you want the carrage returns to be.

A simple way to do that in VB would be: Sql = Sql & vbCrLf

Answer 2

Using SQL code:

UPDATE MyTable
   SET MyCol = MyCol + CHAR(13) + CHAR(10);