RE: Query with variable for "any letter"

Lowell

SSC Guru

Points: 323504

February 17, 2012 at 9:18 am

#1448601

it goes back to what you said you want to do...I might be misunderstanding.

I thought you said you said both find anything and find anything except...

will something like this work for you?

SELECT *

FROM YOURTABLE

WHERE YOURCOLUMN LIKE '%coop_ration%'

AND NOT LIKE '%cooperation%'

SELECT *

FROM YOURTABLE

WHERE YOURCOLUMN LIKE '%coop%ration%' --allows multipe letters between

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!