If you ever need to sort character strings stored in SQL Server fields, check out this demonstration of how to write a common sorting algorithm using SQL Server TSQL code. You are probably familiar ...

What you want to do is insert the data in the database with the ' replaced with '' . This escapes the apostrophe and won't mess up the query.