>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

Just double every single quote inside the message:

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