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?