SQL Search for ' (*RESOLVED*)

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?
:)

Use replace function on the users input and wildcards...
And you'd need to move the single quotes to enclose the asterisks

Code:

---

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

---

Vince

make a double single quote for every single quote?

Silly question does ? mean any char? :)

Hi Bod

If your are using m$ sql server this is your should to the query


SELECT * FROM TableName WHERE TableField like ' %' + char(39) + '%'

Regards
Jorge

The question mark (?) is a wildcard. It looks for any one character in place of the ?

So searching for

50?s

would return anything containing


50Ms
50's
50#s

and so on.

But it would NOT return

50####s

yay I put * in instead of ' and it works :)

Didnt realise what you meant by wild card until my brain kicked in

Thanks you two :D

Thanking me too, Boddy Woddy? :flirt:

Thanks everyone who posted in this thread if I could snog you I would :afrog: