I have a water tank data(.shp) and I need to label it using field NAME. However I just want to label water tank that have names like "Tangki Air Sembulan". If in the field NAME only states "Tangki Air", I do not want the label to appear. Im using Arcgis 10.2 and label using Maplex. I try to use SQL Query like below:
NAM NOT Like '%Tangki Air%'
AND NAM NOT Like '%TANGKI AIR%'
but it's not working. I cannot edit the field name so is there a way that can help me solve this problem?