Here's a strange problem (or at least it's strange to me). I'm using a form to update database records using a UPDATE SQL string. All works fine unless the value of the text field contains a single qoute. For example, if I have a notes field I'm trying to update, this works "Shanes home # is 555-5555" but this does not work "Shane's home # is 555-5555". It produces an error that says "Syntax error (missing operator) in query expression..."<BR><BR>Make sense? Any thoughts??<BR><BR><BR>If a little code helps...<BR>"textNotes" is passed from a previous form and is reidentified on the failing page:<BR><BR>UpdatedNotes=Trim(Request.Form("textN otes"))<BR><BR>My code "seems" to be fine. I just can't include a ' in the field.