Is it possible to create a definition query that will return a subset of values based on a specific field length?
I only want string values where length is less than or equal to 2 characters.
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It only takes a minute to sign up.Sign up to join this community
In ArcMap 10.3.1, I had to change LEN to CHAR_LENGTH.
Select * FROM CHAR_LENGTH(FIELD_NAME) <= 2