Using wildcards in filter expressions 1

[aztech]

I have a database of account names where I need to filter out any account name that begins with the 4-letter abbreviation of our hotels. Here's what I'm using (which is not working):

NOT LIKE N'*DCBH*' OR NOT LIKE N'*DCBR*' OR NOT LIKE N'*LANP*'

I tried the % sign instead of *, but that didn't work either.

Any insight you can provide will be greatly appreciated.

 

[RiverGuy]

Use the % sign, and use AND instead of OR.

 

[aztech]

Thank you! That worked perfectly.

 

[xlbo]

To be clear
use the % for SQL wildcard matches
use the * for Wildcard matches in SSRS itself

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question