1

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.

  • 4
    Please Edit the question to specify the exact data source format, since different source workspaces have differing functions. – Vince Oct 3 '18 at 15:06
2

It should be something like this

Select * FROM

LEN(FIELD_NAME) <= 2

I just tested this in ArcMap 10.5 and it worked.

enter image description here

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.