"NOT LIKE" operator

Is there any way to effect a "NOT LIKE" or "NOT IN" operator when defining thematic labeling or symbology?

Parents Reply
  • Pretty close. In this case, I'm checking the value of the meta_id field (SDSFIE). If the meta_id indicates that the last change was made by a certain party, then I want to label it one way. If it was not changed by that party, then I need to label it differently. The values will be something like

    SomeCo110330

    SomeCo110331

    SomeCo110401

    OtherCo101120

    ...

    I want to label updates by 'SomeCo' in one way, and everything else in another way. I'm trying to make a graphical comparison of the data as I merge it.

    I can handle the first part using a LIKE clause, I just don't have a NOT LIKE to catch features that weren't update by 'SomeCo'. For now, it's not too hard to use ANDed '!='s.

Children
  • Rob;

    The labeling tools was set up to just do fairly simple labeling. If you want to make a graphical comparison based upon the value in each feature instance,you could use the Symbology option for the paticular layer ( feature) in the map manager. Set the symbology type to Thematic, in the first form. You then can specify the feature symbology based upon property values. This also can be saved as a .theme file and reused in another map model.

     

    HTH

    Jerry