https://community.esri.com/t5/arcgis-pro-ideas/add-similar-to-predicate-for-sql-expressions/idi-p/1541404 <P>I have solved an issue with the help of&nbsp;<a href="https://community.esri.com/t5/user/viewprofilepage/user-id/1371">@JoshuaBixby</a>&nbsp;for creating definition queries using REGULAR EXPRESSIONS. I was informed that the LIKE predicate does not work with REGULAR EXPRESSIONS. File geodatabases do support the use of regular expressions and ranges, but with the SIMILAR TO predicate.&nbsp;</P> <P>I have found no documentation stating this works, but it does. It would be best if the SQL EXPRESSION builder has the option to use SIMILAR TO when building SQL EXPRESSIONS and when writing them out.</P> Tue, 19 Nov 2024 00:29:29 GMT BrandonMcAlister 2024-11-19T00:29:29Z https://community.esri.com/t5/arcgis-pro-ideas/add-similar-to-predicate-for-sql-expressions/idi-p/1541404 <P>I have solved an issue with the help of&nbsp;<a href="https://community.esri.com/t5/user/viewprofilepage/user-id/1371">@JoshuaBixby</a>&nbsp;for creating definition queries using REGULAR EXPRESSIONS. I was informed that the LIKE predicate does not work with REGULAR EXPRESSIONS. File geodatabases do support the use of regular expressions and ranges, but with the SIMILAR TO predicate.&nbsp;</P> <P>I have found no documentation stating this works, but it does. It would be best if the SQL EXPRESSION builder has the option to use SIMILAR TO when building SQL EXPRESSIONS and when writing them out.</P> Tue, 19 Nov 2024 00:29:29 GMT https://community.esri.com/t5/arcgis-pro-ideas/add-similar-to-predicate-for-sql-expressions/idi-p/1541404 BrandonMcAlister 2024-11-19T00:29:29Z