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?