Labeling specific comments

Discussion created by hisame on May 16, 2013
Latest reply on May 16, 2013 by rfairhur24
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).

Thank you!