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?

[Ecniv]

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

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

Vince

[erickwidya]

make a double single quote for every single quote?

[BodwadUK]

Silly question does ? mean any char?

[Asgorath]

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

[mendhak]

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

[BodwadUK]

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

[mendhak]

Thanking me too, Boddy Woddy? :flirt:

[BodwadUK]

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