AnsweredAssumed Answered

SQL syntax for numeric wildcard in file geodatabase

Question asked by fnprice on Apr 21, 2016
Latest reply on Apr 21, 2016 by fnprice

Does anyone know what the appropriate SQL syntax is for selecting any record that contains any number within a text string in a field using Select by Attributes with a file geodatabase feature class.  The help page mentions using the pound sign as a numeric wildcard but this isn't working for me so maybe it only works for personal geodatabases?  And I know I can use the field calculator and python or VB to do this in various ways but it just seems like there should be a quicker way to do it with SQL using Select by Attributes.  I'm thinking there should be something like Field_name LIKE '%#%' where the pound sign is any number.

 

Thanks for any pointers!

Outcomes