I'm working on ArcGIS 9.3.1. I have a shapefile with a string field containing point names like these:
10 12 12/13 t/9 6577y 1234 12t9 124y67 u9
and so on (and yes, I know it looks like a colossal mess. It's not my design). Using
WHERE MyColumn LIKE '%Search String%' I can find (using select by attribute) the ones containing a specific letter or a backslash (/).
How can I select all values containing a letter (in this example: t/9, 6577y, 12t9, 124y67, u9), not caring what letter it is or it's position? (is there a way to specify a position?)