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!