I have polygons that I need to label. The expression it looks something like [shapefile.name]&vbnewline&[shapefile.comment]
However in the comment I have two values (A and B). I want to only display on map, comment value A and not comment value B.
Is there a way to achieve this? I tried the SQL Query but that gets rid of the entire labeling (I still want the name to show up even if the polygon has comment value B).