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.
0 kommentar(er)
