> eg. Christopher's Egg. The apostrophe would normally give an error. I wrote a routine to remove them automatically when typed in the text box. The ideal situation would be to include those apostrophe.

If you double up the apostrophe's SQL Server will read it as one instead of a string delimiter.

SELECT 'Christopher''s Egg'

-Mike