Sign up for E-mail updates on the Soil Series Classifications (SCs)

Wildcards

The following wildcards may be used:

* Evaluates to zero or more characters.

   'HAP*'    all strings that begin with HAP
   '*.'      all strings that end with a period
   '*NOT*'   all strings that contain the substring NOT

? Evaluates to a single character.

   '???F*'   all strings with F as the fourth character

[] Any single character within the specified range or set.

   '[A-N]*'  all strings that begin with a letter A to N
   '[A-NS]*' all strings that begin with a letter A to N, or S

[^] Any single character not within the specified range or set.

   '[^A-N]*' all strings that do not begin with a letter A to N

The single quotes that surround the search string will be supplied automatically.

Caution:
Using wildcards as the initial part of a comparison string often causes the query to take longer to execute.
This is because database indexes cannot be used, so every row of data must be searched.