SQL = ". .like '" & Mike's Garage & "*'"
Posted on 1998-11-19
Variable = "Mike's Garage"
SQL = "..like '" & Variable & "*'". . the variable used contains a possesive "Mike's" which fouls up the SQL statement because of the apostrophe. How can I parse this out so the SQL looks for the record, since the record says "Mike's Garage" not "Mikes Garage". The SQL statement, because of the apostrophe in the name, stops at 'Mike' looking for an operator. help help.