I have a feature class for fire stations, and I'm trying to label only those fire stations that have a ladder truck (based on the [APPARATUS1] field), but I can't get the wildcard expression to work. Conversely, when I use the = operator, it returns the value just fine ([ID] is the station number) and labels the appropriate station:
Function FindLabel ( [ID], [APPARATUS1] )
if ( [APPARATUS1] = "Ladder 100' Tiller" ) then
FindLabel = "Station " & [ID] & vbnewline & [APPARATUS1]
end if
End Function
But when I try to catch all the stations with ladders, I only get syntax errors with the following wildcard expression:
Function FindLabel ( [ID], [APPARATUS1] )
if ( [APPARATUS1] LIKE "Ladder%" ) then
FindLabel = "Station " & [ID] & vbnewline & [APPARATUS1]
end if
End Function
Any help in figuring out what I'm missing would be much appreciated. I've tried various combinations of single-quotes, asterisk wildcard character, etc., but nothing works. Thanks!