idea ArcGIS Pro add SQL Selection Ranges in ArcGIS Pro Ideas

ArcGIS Pro add SQL Selection Ranges

JoeBorgione — Tue, 27 Mar 2018 18:21:10 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:58:26 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?

Re: ArcGIS Pro add SQL Selection Ranges - Status changed to: Closed

SSWoodward — Wed, 26 Oct 2022 18:32:13 GMT

This idea has been closed as a duplicate of the Data Management Idea linked below. Don't worry, you can still show your support by commenting and adding kudos to the open idea. Thanks for your contributions!

https://community.esri.com/t5/data-management-ideas/arcgis-pro-add-sql-selection-ranges/idi-p/929293