Hi,
Not sure if this is in the correct section but as my issue is in VB6, thought I'd ask here!
Just wondering how to get round a name search when you store in the database "O'Neil" and want to do a search?
Obviously an Sql statement can't read:-
SELECT * FROM Customers WHERE Name Like 'O'Neil'
So what's the best way round it?
Cheers in advance,
Carl.
Also posted in VB6 Forum here!
Not sure if this is in the correct section but as my issue is in VB6, thought I'd ask here!
Just wondering how to get round a name search when you store in the database "O'Neil" and want to do a search?
Obviously an Sql statement can't read:-
SELECT * FROM Customers WHERE Name Like 'O'Neil'
So what's the best way round it?
Cheers in advance,
Carl.
Also posted in VB6 Forum here!