Persons with disabilities who require alternative means for communication of soil survey information should contact the NRCS office at the USDA Service Center that services the county of interest. See also the NRCS Accessibility Statement.
SC View by Query
USDA Home NRCS Home USDA Home SC View by Query
  Contact Us

GovDelivery envelope image 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.