I would like to know if someome can help me to build a search string using ADO 2.1 , VB 6.0 and MS SQL 6.5 / 7.0.
I built this string:
Rst.Open "SELECT * FROM Company WHERE Company = '" & ltCompany.Text & "'"
It works almost OK, but fail when I try to search for "World's Company"
with the following error:
Thanks for any help