If a user submits a form with a word which contains an apostrophe &#039 this causes a SQL Error.<BR><BR>When a variable called strClub includes an apostrophe (eg strClub = "sam&#039s place") there is an SQL error. Is there any way I can check the value of the variable strClub to see if it contains an apostrophe, remove it and then parse the SQL ? If so how do I code it ?