The NULL keyword is always preceded by IS or IS NOT. For example, this expression would find Catherine Smith and Katherine Smith: OWNERNAME LIKE 'atherine smith'You can use greater than, less than (=), less than or equal, and BETWEEN operators to select string values based on sorting order. Alternatively, if you want to search with a wildcard that represents one character, use an underscore. For example, this expression would select Mississippi and Missouri among United States state names: STATENAME LIKE 'Miss%'The percent symbol (%) means that anything is acceptable in its place: one character, a hundred characters, or no character. For example, the following expression will select the state whose name is stored as 'Rhode Island' or 'RHODE ISLAND': UPPER(STATENAME) = 'RHODE ISLAND'If the string contains a single quotation mark you will first need to use another single quotation mark as an escape character, for example: NAME = 'Alfie's Trough'Use the LIKE operator (instead of the = operator) to build a partial string search.

For file-based data sources such as geodatabases or shapefiles, you can use the UPPER or LOWER function to set the case for a selection.

Nombres de paises de 8 letras