>Why does SQL server care about the content of the memo field? <g>. I noticed that on the conversion, it checks for closed parenthesis and other grammatical nonsense <g>. Is there a way to make SQL Server ignore those things and just store the value in text type?
>
>TIA.
>
>P.S. Good thing SQL Server does not check for spelling errors <g>

It doesn't. What it does care about are embedded single quotes when you are executing a text command instead of a stored procedure. You can get by with replacing each single quote with two single quotes. But it is a gazillion times better to use a stored procedure when sending text to SQL Server.