Can anyone tell me how you'd use the UPDATE command in T-SQL to update a memo field that had imbedded CRLF and quotes, etc. For example, if you wanted to update a text field (memo type, unlimited) with the following info:

UPDATE mytable SET mymemofield = '
This is a note we wrote
and it's on multiple lines
and "fred" wrote it. '
WHERE key = '1234'


As you can see from the above, the note itself includes quotes (single and double) in addition to CRLF.

What delimeter could we use so that the quotes don't mess things up, and will the embedded CRLF mess it up?

Thanks.

Bob