how to find a simple quote in a row

Hi,
I have a table with a "description" row.
In this row I may have some simple quote (') character.
How can I select them ?
something like :
select * from myTable where description like %'%
thanksselect * from myTable where description like %''%

Use TWO single quotes. They are treated as one.|||don't forget the quotes around the pattern :)

... where description like '%''%'|||Other alternative is

select * from tableName where charindex('''',Colname)>0