Problem executing String search on TEXT Field

Discussion created by johancz on Jul 31, 2011
Latest reply on Aug 1, 2011 by johancz
Hello everybody,
Is there a way how to search records in String Field for spaces?
Example: I have field with names of U.S. states, (all STRING data type) and I want to find between them records containing space character - like: "New York" or "Los Angeles" . ive tried an SQL expression in Table Select Tool which was: "name" LIKE '% %' But turns into Error. (invalid SQL expression) Also tried "name" LIKE '%_%' but this returned ALL records.
I just dont understand it...
Any help appreciated thanks, JOHN,

platform is ArcGIS 9.3 with ArcView licence