AnsweredAssumed Answered

Excluding Multiple Words from Labeling

Question asked by trevinomd on May 7, 2013
Latest reply on May 7, 2013 by rborchert
I want to be able to label my streets with defined classes so I get FSC = 'Freeway' in my SQL query but, I also want the query to exclude any labels like OFFRAMP, ONRAMP, FRONTAGE, ect. I can get the query to exclude one or the other for example:
FSC  = 'FREEWAY'  AND NOT FULL_NAME LIKE '%RAMP%'  will exclude all the 'RAMP' but when I go to add the frontage to the query it makes the '%RAMP'% query no longer work. How do I get both not to show up and preserve my main FSC = 'Freeway' query?

(FSC  = 'FREEWAY'  AND NOT FULL_NAME LIKE '%RAMP%' ) OR (FSC  = 'FREEWAY'  AND NOT FULL_NAME LIKE '%FRONTAGE%')

This didn't work either.

Thanks for any help.

Mike T

Outcomes