Thanks Bill
>Hi Terry,
>>If a person submits text like the following:
>>
>>"John's Steakhouse" as a company name, how would I handle it before inserting that text into a text or char or varchar type field so as to not confuse SQL Server while still keeping the intent of the end user and their formal companies name?
>
>If you double the single quote you will get the desired result. i.e.
>"John
''s Steakhouse"
>
>In our VFP app with a SQL backend, we have standardized on using the [] as quotes and then strtran() the single quote to double them.
>HTH,