I have road polyline data that contains names in both the [Full_Name] and [Alias1] fields that I want to use for labeling the features. I want to have the below script check for "CR xxx" in the [Full_Name] field, and use it if exists. If it doesn't exist as such, I want it to label using the [Alias1] field instead, but is not working correctly as is (below). Can someone suggest how I may change the script to do so above? - Thank you, Barry.
Function FindLabel ( [Full_Name], [Alias1] )
if ( [Full_Name] = "CR %" ) then
FindLabel = [Full_Name]
FindLabel = [Alias1]