in sql if you are inserting a value in to a text field, when there is a ' in the text string i get an error... is there any way to allow ' in a text string when you are using SQL?