>My INSERT statement includes data for a memo field and the data may include text with embedded carriage returns. This is throwing a syntax error when executed. Can someone tell me how to encode the string (from VBNET) so it will execute?
>Thanks

Can you post your exact statement that gives an error? If you're using parameters, the carriage return should not matter and should not give any errors.