Thanks Sergey

>A simple fix is to double a single quote as you would do in SQL Server
>

>lcUpdateString = CHRTRAN(lcUpdateString, ['], [''])
>

>
>
>>I have a small issue with when a user adds a single quote ' mark within the string. It doesn't happen real often, but once or twice a month, and the update fails on the sql server side.
>>
>>Example:
>>lcUpdateString=[DC'd and intact]
>>
>>I think I could write a routine that could be called and loop through the string, looking for the ' and putting it inside a set of double quotes. My questions:
>>
>>1. Would that work?
>>2. Would it effect the vfp code below?
>>3. Is there an easy way to do that type of code?
>>
>>
>>VFP Code:
>>

>>lcCmd=[Update dbo.co_Pat_IVTable set ]+lcUpdateTextColumn+[=']+lcUpdateString+[', ]+lcUpdateIDColumn+[= ']+lcNewValues+[']
>>lcCmd=lcCmd+[ where RecordID=?lnUpdateID]
>>

>
>>
>>
>>Thanks for your thoughts, insights, suggestions
>>
>>Kirk