For more, see Information Tools, Quick Search, SQL Expression
An operator is the action part of a query, performed on a set of feature attribute data values and applied criteria when querying...
= : equal to
< : less than
> : greater than
>= : greater than OR equal to
<= : less than OR equal to
<> : not
Like : Searches for records that contain the search value anywhere within. For example, a Like search with 45 as the search value could produce results, 8450, 450, Hyd-45, etc.*
Left : Requires that all results have the entire search value and allows results to contain anything else beyond it to the right. For example, with a search value of 45, the following would be valid results: 4530, 45b, 45.98 (not 345, 2.45); with a search value of WEST the following would be valid: WESTLINE, WESTWOOD, WEST WAY (but not NORTHWEST, WILDWESTWOOD, etc). **
*When performing a LIKE search with SQL, place a percent sign % on either side of the search value (inside the single quotation marks when searching a STRING field). Example expression: FULLNAME Like ‘%CAR%’
**When performing a LEFT search with SQL, select LIKE as the operator and then place a percent sign % after the search value (inside single quotes when searching a STRING field). Sample expression: FULLNAME Like ‘CAR%
In SQL Expression, perform a RIGHT search by following the same procedures as a LEFT search except place the % before the search value. For example, to search for all records ending with a '05' the expression should read as follows: (field name) Like %05