AnsweredAssumed Answered

Why does FIELDNAME LIKE '% %' not work in 10.3.1 file geodatabase table?

Question asked by rfairhur24 on Mar 6, 2017
Latest reply on Mar 6, 2017 by rfairhur24

I am very frustrated that whenever I try to query for a space character using a LIKE query that I never get any results from a file geodatabase table.  If I query FIELDNAME LIKE '% %' nothing is returned, even though I know there are values that match that criteria (most of them do).  I do not recall having this problem in 10.3 or 10.2, although it has been a while since I have had those versions.

 

Does this type of query work in ArcMap 10.3.1?  If others do not have this problem then perhaps the database needs repair, but I want to know that it works for someone before trying that route since the tables are large.

 

If it doesn't work how do I find records with two or more words separated by spaces in a fields using a query on a 10.3.1. file geodatabase table?

Outcomes