SQL Search for ' (*RESOLVED*)

[BodwadUK]

I think this is the right forum for it

Its an SQL question

how do I do a search for a string containing the ' char eg

50's 60's etc. Whenever I try I get an operator error because ' is a used element in SQL. You must be able to search for it though cant you

E.g

SELECT * FROM [AllTable] WHERE [AllIdeas] LIKE *'50's'*

I tried

SELECT * FROM [AllTable] WHERE [AllIdeas] LIKE *'[50's]'*


Anyone know this one?