Searching for a name with an apostophe

[Guest_imported]

Can someone help me. I need to search a SQL table for the name "O'Niell" using LIKE.

I can't do a

SELECT * FROM employees WHERE name LIKE 'O'Niell%'
- or -
SELECT * FROM employees WHERE name LIKE "O'Niell%"

so how would I do this.

CR

 

[karluk]

Try using two consecutive apostrophes:

SELECT * FROM employees WHERE name LIKE 'O''Niell%'