CHAR_LENGTH is a SQL Function that is being used in the SQL query for most of the RoadCenterline label classes that include road shields. These label classes and their associated SQL queries are: Interstate_Shield - "RoadClass" IN (1 , 2) AND "HIGHWAYTYPE" = 1 AND CHAR_LENGTH ( "HWY" ) < 3 US Highway_Shield - "RoadClass" IN (1 , 2 ) AND "HIGHWAYTYPE" = 2 AND CHAR_LENGTH ( "HWY" ) < 3 State Highway_Shield - "RoadClass" IN (1 , 2 ) AND "HIGHWAYTYPE" = 3 AND CHAR_LENGTH ( "HWY" ) < 3 Interstate_WideShield - "RoadClass" IN (1 , 2) AND "HIGHWAYTYPE" = 1 AND CHAR_LENGTH ( "HWY" ) >= 3 US Highway_WideShield - "RoadClass" IN (1 , 2) AND "HIGHWAYTYPE" = 2 AND CHAR_LENGTH ( "HWY" ) >= 3 State Highway_WideShield - "RoadClass" IN (1 , 2) AND "HIGHWAYTYPE" = 3 AND CHAR_LENGTH ( "HWY" ) >= 3 These queries control the shield symbol that will be used for various route numbers. Any route numbers that are less than 3 characters will use the smaller shields and any that are 3 or more characters will use the wide shields. You can find the Label classes and SQL queries in the Label properties tab. Let me know if you need any other information. Thanks, -Kate
... View more