Now that you say it, I remember that I wrote some code that looked at the string and doubled up the ' when building the INSERT statement. Thanks for the memory jog.
Gary
>>Hi,
>>I need to embed single quotes in an sp string to SQL Server 2k, e.g. "O'Mally", and cannot for the life of me remember how. I'm sure I've done it in the past. At least I *think* I'm sure I've done it before! Anybody know how?
>>
>Gary,
>
>Double them inside a string literal.
'O''Mally'