Advanced Search

Run an advanced search when you need to find chemical datasheets by:

  • Searching on additional fields besides the ones available in a simple search (name, CAS numberOr CAS #. Chemical Abstracts Service Registry number. This chemical identification number, in the format XXX-XX-X, is assigned by the American Chemical Society (www.cas.org/support/documentation/chemical-substances/faqs)., or UN/NA numberUnited Nations-North American number. (Also UN number or DOT number.) Four-digit number identifying an individual chemical or group of chemicals with similar characteristics. Required on shipping papers; often shown on placards. The four-digit number is often preceded by UN (such as UN1219).).
  • Searching on multiple criteria at the same time (that is, running an AND searchType of advanced search that uses multiple search criteria and only finds datasheets that match ALL of the criteria.) to find datasheets that match ALL your criteria.

Create an advanced search string by choosing a search field, a search operator, and entering a search term.

Running an Advanced Search

Note: The search isn't case sensitive and it will only find chemical datasheets. If you want to search for UN/NA datasheets or reactive group datasheets, you must use a simple search.
  1. In the sidebar, click New Search. (On the home page, you also can click Search.)
  2. Click on the Advanced Search link at the bottom of the gray search box. See the Advanced Search linkSee the Advanced Search link

    The Advanced Search link is at the bottom of the gray search box.

  3. Mix and match among three kinds of searches to construct an advanced search:
    • Searching text fields. Search within a text information field (such as name or DOT hazard labelRequired DOT hazard warning label for the chemical (such as flammable liquid or corrosive).) or an identification number field (such as a CAS number). Text field instructionsText field instructions

      In the Search Text Fields section, go to the first row and then:

      1. Choose a field to search within (such as General Description or USCG CHRIS codeThree-letter code used by the U.S. Coast Guard to identify individual chemicals in the CHRIS (Chemical Hazards Response Information System) guide to chemical hazards.) from the first drop-down list.
      2. Choose a search operator from the second drop-down list:
        • equals (means the text in the field exactly matches your criteria),
        • starts with (means the text in the field starts with your criteria),
        • contains (means the text in the field contains your criteria, word order is not important),
        • contains exact phrase (means the text in the field contains your criteria exactly as you typed it, including punctuation and spaces between words),
        • is not empty (means the field contains text), or
        • is empty (means the field contains no text).
      3. Skip this step if you picked "is empty" or "is not empty"; otherwise, enter a search term or value (that is, your search criteriaName, identification number, and/or other identifying information for a chemical.). For example, "acrolein" for a search of the Name field or "flammableEasy to ignite and burns readily." for a search of the DOT hazard labelRequired DOT hazard warning label for the chemical (such as flammable liquid or corrosive). field.
      4. Click Search to run the search.
    • Searching numeric fields. Search within a field containing physical property data (such as boiling pointTemperature at which a liquid boils and changes to a gas (typically under normal atmospheric pressure). Above its boiling point, a chemical is a gas. The boiling point depends on a chemical's composition and the applied pressure. As pressure increases, the boiling point of a substance also increases. or vapor pressureA measure of a substance's tendency to evaporate; liquids with higher vapor pressures evaporate faster.) or a level of concern (such as IDLHImmediately Dangerous to Life and Health limits, levels of concern for adult workers; estimate of the highest concentration in air from which escape is possible without permanent injury (if their respirators fail). IDLHs are established by the National Institute for Occupational Safety and Health (www.cdc.gov/niosh).). Numeric field instructionsNumeric field instructions

      In the Search Numeric Fields section, go to the first row and then:

      1. Choose a field to search (such as boiling pointTemperature at which a liquid boils and changes to a gas (typically under normal atmospheric pressure). Above its boiling point, a chemical is a gas. The boiling point depends on a chemical's composition and the applied pressure. As pressure increases, the boiling point of a substance also increases. or IDLHImmediately Dangerous to Life and Health limits, levels of concern for adult workers; estimate of the highest concentration in air from which escape is possible without permanent injury (if their respirators fail). IDLHs are established by the National Institute for Occupational Safety and Health (www.cdc.gov/niosh).) from the first drop-down list.
      2. Choose a search operator from the second drop-down list:
        • equals (means the number in the value field equals your criteria),
        • is less than (means the number in the value field is less than your criteria),
        • is greater than (means the number in the value field is greater than your criteria),
        • is less than or equal to (means the number in the value field is less than or equal to your criteria),
        • is greater than or equal to (means the number in the value field is greater than or equal to your criteria),
        • is not empty (means the value field contains a number), or
        • is empty (means the value field contains no number).
      3. Skip this step if you picked "is empty" or "is not empty"; otherwise, enter your numeric search term (that is, your search criteria). For example, "760" for a search of the vapor pressureA measure of a substance's tendency to evaporate; liquids with higher vapor pressures evaporate faster. field). Do not enter any units.
      4. Click Search to run the search.
      Note: Units aren't standardized, because the information in the chemical datasheets in CAMEO 365betÓéÀÖ is drawn from many sources. For example, water solubility may be shown in any of a variety of units, such as %, g/100 g, and mg/mL.
      Note: The numeric "field" information that you see on a chemical datasheet (for instance, the boiling point data) is really the combination of up to four fields (value, units, range, and notes) from the underlying database. When you do an advanced search on a numeric field, it only searches the value field.
    • Searching Boolean (yes/no) fields. Search within a Boolean field to find yes/no answers. For instance, you can find out whether or not a substance is listed in the regulatory fields related to Extremely Hazardous Substances under EPCRAEmergency Planning and Community Right-to-Know Act (also know as SARA Title III). Defines list of chemicals that are classified as Extremely Hazardous Substances (EHSs) and requires planning for and reporting of EHS releases from facilities (www.epa.gov/epcra). (Section 302 and 304), Hazardous Substances under CERCLAComprehensive Environmental Response, Compensation, and Liability Act of 1980 (also known as Superfund). Creates a framework for federal involvement in response and cleanup activities following hazardous substance releases. For more information, see www.epa.gov/superfund/superfund-cercla-overview., Toxics Release Inventory under EPCRA (Section 313), or the Risk Management Program under Section 112(r) of the Clean Air Act (CAAClean Air Act of 1990.). You can also find out whether chemical records have information on DuPont Suit Fabric Breakthrough Times, whether you may be able to select the chemical in ALOHA to model a hazardous chemical release, whether the chemical is a CISA CFATS Chemical of Interest, whether the chemical is an OSHA PSM Hazardous Chemical, and whether the chemical datasheet includes external hyperlinks to a NIOSHNational Institute for Occupational Safety and Health (www.cdc.gov/niosh). The federal agency responsible for conducting research and making recommendations for the prevention of work-related disease and injury. NIOSH is part of the Centers for Disease Control and Prevention (CDC). Pocket Guide page or an International Chemical Safety Card page.

How do I...?

  • Know when to use the "contains" versus "contains exact phrase" search operators?Know when to use the "contains" versus "contains exact phrase" search operators?

    For single-word search criteria, these search operators are identical and they will produce the same results. For multi-word search criteria ("words" are separated by spaces), they will produce different results. (Either operator can find mid-word matches within the field, see the examples below.)

    If you use the contains operator, CAMEO 365betÓéÀÖ will find matches that include ALL of the words in your search criteria. It doesn't matter if the words are in the same order as your search terms or in a different order. For example, searching on "General Description contains red liquid" finds matches that include phrases such as "reddish-yellow oily liquid", "copper-colored or yellow liquid", and "red liquid with an odor like rotten eggs". With this operator, the search results page will also include a breakdown of the search results as a phrase and for each individual word in the phrase. You can click on the links next to the single-word results to see the list of datasheets that contain just that word in the chosen field (e.g., datasheets with "liquid" in the General Description).

    Search results excerpt showing matches for General Description contains red liquid.

    If you use the contains exact phrase operator, CAMEO 365betÓéÀÖ will only find matches where the search term is an exact match to what you typed (including punctuation and spaces between words). For example, searching on "General Description contains exact phrase red liquid" finds matches that include phrases such as "light-yellow colored liquid" and "a yellow to dark red liquid", but it will not find any matches where "red" and "liquid" are separated in the phrase. Because this search is looking for an exact match, the search results page does not include a breakdown of matches for each word in the phrase.

    Search results excerpt showing matches for General Description contains exact phrase red liquid.

  • Know whether a number is a text field or a numeric field?Know whether a number is a text field or a numeric field?

    Most fields that contain numbers are treated as numeric fields; however, a few are treated as text fields because they are identification numbers.

    Searching on identification number requires the text field search operators (such as starts with or contains) rather than the numeric field search operators (such as is less than or is greater than):

    For identification numbers, you are searching for a match to all or part of a particular number (such as chemicals with a particular UN/NA number). For physical property numbers, you may be searching for an exact match to a numeric value (such as chemicals with specific gravity equal to 1) or a range of matches (such as chemicals with a boiling pointTemperature at which a liquid boils and changes to a gas (typically under normal atmospheric pressure). Above its boiling point, a chemical is a gas. The boiling point depends on a chemical's composition and the applied pressure. As pressure increases, the boiling point of a substance also increases. less than 100°F).

Example Searches

  • Text field searchesText field searches

    A search for substances with a USCG CHRIS codeThree-letter code used by the U.S. Coast Guard to identify individual chemicals in the CHRIS (Chemical Hazards Response Information System) guide to chemical hazards. of HTN looks like this, and finds the chemical datasheet for heptanol:

    Example search for a CHRIS Code.

    Sometimes you might know what a hazardous substance looks or smells like. You can use such physical clues in a search for the substance's datasheet. For example, a search for chemical datasheets in which the General Description field contains "yellow powder" finds 225 chemicals.

    Example search of the general description field looking for a match on both "yellow" and "powder".

    If you have only part of a substance's name or identification number (for example, a label may be torn or partially burned), you can use that information in an advanced search. For example, a search for datasheets in which the UN/NA numberUnited Nations-North American number. (Also UN number or DOT number.) Four-digit number identifying an individual chemical or group of chemicals with similar characteristics. Required on shipping papers; often shown on placards. The four-digit number is often preceded by UN (such as UN1219). starts with 10 finds 94 chemical datasheets that have UN/NA numbers beginning with 10. This search looks like:

    Example search of the UN/NA number field looking for numbers that start with "10".

  • Numeric field searchesNumeric field searches

    A search for datasheets in which the chemical's "melting pointAlso called freezing point. The temperature at which a chemical changes from a solid to a liquid. Depends on chemical composition and applied pressure. is less than -50" finds 430 chemical datasheets. This search looks like:

    Example search looking for chemicals that have melting points less than -50.

    A search for datasheets in which the chemical's "vapor pressureA measure of a substance's tendency to evaporate; liquids with higher vapor pressures evaporate faster. is greater than or equal to 760" finds 36 chemical datasheets; 760 mm Hg is atmospheric pressure at sea level. This search looks like:

    Example search looking for chemicals that have a vapor pressure that is greater than or equal to 760.

  • Boolean field searchesBoolean field searches

    Below is a search for datasheets that (a) have information in the CERCLAComprehensive Environmental Response, Compensation, and Liability Act of 1980 (also known as Superfund). Creates a framework for federal involvement in response and cleanup activities following hazardous substance releases. For more information, see www.epa.gov/superfund/superfund-cercla-overview. column of the regulatory table and (b) may be selectable in ALOHA. It finds 269 chemical datasheets that match both criteria.

    Example search for chemicals that are regulated under CERCLA and which may be selectable in ALOHA.

  • Multiple criteria searchesMultiple criteria searches

    To include multiple criteria in your search, fill in more than one row of search boxes. The search will find the chemical datasheets that match ALL your criteria.

    For example, a search for chemicals with an NFPANational Fire Protection Association (www.nfpa.org), a private, non-profit organization that produces technical data related to fire protection and prevention, including the widely used NFPA diamond that contains codes representing chemical hazards. rating of 4-4-4 finds four chemicals (see the NFPA diamond page for more details about NFPA ratings). This search looks like:

    Example search for chemicals with 4-4-4 as their NFPA diamond rating.

    Note: Use a text field search to search for NFPA Special codes.

    Example search for chemicals that have "No Water" as their special NFPA diamond code.