idea ArcGIS Pro add SQL Selection Ranges in Data Management Ideas

ArcGIS Pro add SQL Selection Ranges

JoeBorgione — Thu, 06 Oct 2022 18:34:50 GMT

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...."

Re: ArcGIS Pro add SQL Selection Ranges

JoshuaBixby — Tue, 22 Jun 2021 08:56:14 GMT

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.

Re: ArcGIS Pro add SQL Selection Ranges

JoeBorgione — Tue, 27 Mar 2018 19:23:57 GMT

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

Re: ArcGIS Pro add SQL Selection Ranges

KoryKramer — Wed, 28 Mar 2018 14:09:28 GMT

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?