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 number , or UN/NA number ).
- Searching on multiple criteria at the same time (that is, running an AND search ) to find datasheets that match ALL your criteria.
Running an Advanced Search
- In the sidebar, click New Search. (On the home page, you also can click Search.)
- Click on the Advanced Search link at the bottom of the gray search box. See the Advanced Search linkSee the Advanced Search link
- 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 label ) 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:
- Choose a field to search within (such as General Description or USCG CHRIS code ) from the first drop-down list.
- 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).
- Skip this step if you picked "is empty" or "is not empty"; otherwise, enter a search term or value (that is, your search criteria ). For example, "acrolein" for a search of the Name field or "flammable " for a search of the DOT hazard label field.
- Click Search to run the search.
- Searching numeric fields. Search within a field containing physical property data (such as boiling point or vapor pressure ) or a level of concern (such as IDLH ). Numeric field instructionsNumeric field instructions
In the Search Numeric Fields section, go to the first row and then:
- Choose a field to search (such as boiling point or IDLH ) from the first drop-down list.
- 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).
- 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 pressure field). Do not enter any units.
- 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 EPCRA (Section 302 and 304), Hazardous Substances under CERCLA , Toxics Release Inventory under EPCRA (Section 313), or the Risk Management Program under Section 112(r) of the Clean Air Act (CAA ). 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 NIOSH Pocket Guide page or an International Chemical Safety Card page.
- Searching text fields. Search within a text information field (such as name or DOT hazard label ) or an identification number field (such as a CAS number). Text field instructionsText field instructions
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).
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.
- 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 point less than 100°F).
Example Searches
- Text field searchesText field searches
A search for substances with a USCG CHRIS code of HTN looks like this, and finds the chemical datasheet for heptanol:
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.
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 number starts with 10 finds 94 chemical datasheets that have UN/NA numbers beginning with 10. This search looks like:
- Numeric field searchesNumeric field searches
A search for datasheets in which the chemical's "melting point is less than -50" finds 430 chemical datasheets. This search looks like:
A search for datasheets in which the chemical's "vapor pressure is greater than or equal to 760" finds 36 chemical datasheets; 760 mm Hg is atmospheric pressure at sea level. This search looks like:
- Boolean field searchesBoolean field searches
- 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 NFPA rating of 4-4-4 finds four chemicals (see the NFPA diamond page for more details about NFPA ratings). This search looks like:
Note: Use a text field search to search for NFPA Special codes.