If in a VB Application i pass a search string to query a SQL Server table, lets say the search string is Bob's Texeco. To test this i ran SQL Server Enterprise Manager and ran a simple SQL Query...

SELECT *
FROM admin.customer_table
WHERE (NAME = 'Bob's Texaco')

When i run this i get the following error....

[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1:Incorrect syntax near 's'

the ' in between Bob and the s seems to be the issue. How would i correct this.

Thanks
Frank