Example SQL statement:

txtTitle.Text = "Frame's"

"SELECT Titles as intTitle WHERE Title = '" & txtTitle.Text & "'"

It gives me an error referring to the single quotation in Frame's.

I tried replacing the Frame's with Frame\'s and even Frame/'s but it still didn't like it. If I remove the single quote then it behaves properly!

How can I fix this? I would like NOT to eliminate single quotes from my database!

Thanks in advance!

<c>