How do I isolate a few characters to not show up in my results?

Question

question

Slick84 asked Aug 2, '11

How do I isolate a few characters to not show up in my results?

I have promo codes with 6 characters each. Like so: AOIE0S and so on... now I dont want this particular one showing up in my results because it's got both a "Zero" and an letter "O". I dont want any promo codes with zeroes or the letter o's showing up in my result set. I tried my query but it won't work.
---------- select code from promo_tbl where code not like '_0' and code not like '_o' ----------

tsql

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 1 · 2011-08-02T10:59:17Z

Tim answered Aug 2, '11

You forgot to specify the wild card %

4

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Tim commented · Aug 02, 2011 at 11:36 AM

It happens to us all. Me more so than others. :)

1 ·

Slick84 commented · Aug 02, 2011 at 11:12 AM

I didnt know you had to include the % wild card when I was already using the _ wild card. This is what worked for me but your answer led me to it. --- code not like '%O_%' and code not like '%0_%' ---

0 ·

Tim commented · Aug 02, 2011 at 11:23 AM

I didn't want to give you the entire answer, just wanted to lead you to it. '%0%' and '%O%' should work as well. Glad you got it working the way you need.

0 ·

Slick84 commented · Aug 02, 2011 at 11:30 AM

yeah, lol i was looking into other wildcard characters so much that i forgot my basics..

0 ·

question