I am writing a program to search an Access Database using SQL and ASP. In my database i have cells that contain apostrophes in them... that poses a problem when someone enters and single quote to search because the SELECT * FROM table WHERE name=mike's gives me an error because of the apostrophe.

How can i do this?