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,