Is This Content Helpful?
We're glad to know this article was helpful.
Certain characters, such as an asterisk, may be reserved in SQL statements as wildcards, depending on the source data type. If a string contains that character, using it in Select by Attributes requires an escape character.
Example of using escape characters to select records containing a character normally read as a wildcard:
In the file geodatabase, the "ESCAPE" keyword can be used to designate another character as the escape character. For for information, see the help link in Related Info.