SQL Query: That Contain Apostrophe

Hi Friends,

I have stored names with ' s (Apostrophes) and without 's  in the database(sqlserver).Example:O'Relly

I tried to get the values with select statement like

Dim str As String = Request.QueryString("Title")

Dim query As String = "SELECT * FROM Test where title like '" + str + "'"

Problem is getting the all the values from database except O'Relly just getting O other word Relly no.....

What should do I and what code do I need ..?

 

I tried with the below code also

Dim x As Long

For x = 1 To Len(str)

If Mid$(str, x, 1) = "'" Then

str = str & "''"

Else

str = str & Mid(title1, x, 1)

End If

Next

 

 

Need help ,

Thanks.