ArcGIS Pro add SQL Selection Ranges

125
3
03-27-2018 11:21 AM
Status: Open
Labels (1)
JoeBorgione
MVP Esteemed Contributor

Char_Field like '[A-Z]%'

Char_Field like '%[1-9]%'  

etc.

You've never been able to do this in a File Geodatabase, but wouldn't it be cool if someday you could?

"You may call me a dreamer; but I'm not the only one...."

Tags (2)
3 Comments
JoshuaBixby

Basically the same suggestion:  https://community.esri.com/ideas/14378 .  For the time being, Esri seems to be sticking with "Not in Product Plan," so don't go holding your breath.

JoeBorgione

You got my vote on it Joshua!  Maaaybee someday?!

KoryKramer

As stated in that other idea, the explanation from development about this functionality is "SIMILAR TO has been implemented in the File Geodatabase. It is a SQL standard implementation that provides access to Regular Expressions. Using Regular Expressions on like is not part of the SQL standard, even though many RDBMS systems have chosen to add support. With File Geodatabase SQL we follow the SQL standard wherever possible."

Would you be able to use Similar To?