SQL syntax for numeric wildcard in file geodatabase

3657
10
Jump to solution
04-21-2016 11:07 AM
FrankPrice
New Contributor III

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!

0 Kudos
10 Replies
FrankPrice
New Contributor III

Thanks for your help with it!

0 Kudos