|
|
 |
| Help - HSDB Field Searching |
 |
|
Each database/collection has an Advanced Search page which allows you to search in the specific fields for that database/collection. Using the Advanced Search page, you can:
- build your search step-by-step using the boxes at the top of the Advanced Search page,
or
- type your query statement, including all appropriate syntax, in the Query box.
To search in a specific field, click on the drop down button next to All Fields and select the desired field, e.g. IdentificationNumber. The most frequently searched fields are listed first. To find out the appropriate names of all fields, turn on the Field Help from the toolbar and click on the ? help symbol next to the field in any database record. You can now view the field name and its description.
Use the information below as a guide to executing detailed searches using the HSDB Advanced Search page:
Major Search Fields
Search Examples
Field Summary (Names To Be Used For Searching)
These are the frequently searched fields listed in the drop down list on the Advanced Search page.
|
Searching using: |
Finds information in these fields: |
|
AllFields |
All fields |
| Name
|
Substance Name
Synonyms
|
| IdentificationNumber
|
CAS Registry Number
Shipping Name Number
STCC Number
|
| MolecularFormula |
Molecular Formula
|
| HealthEffects |
related to human health and toxic effects
|
| AnimalToxicity
|
related to animal health and toxic effects
|
| EnvironmentalEffects
|
environmental fate and exposure pontential
|
| UsesAndSources
|
ManufacturersLabel(Major Uses)
Sources and Concentrations (Natural Occuring Sources, Artificial Sources)
|
| Note: All fields have been indexed. Each field has a specific name which must be used for searching. Use the Field Summary to view the specific
"field names" to be used for searching. |
Tip: For a complete list of database fields, while viewing a database record, turn on the Field Help from the toolbar and click on the ? help symbol next to the field in any database record. You can now view the field name and its description, from the complete list of fields for the database. You can easily print this list, by clicking in the field help window, right-clicking and then selecting Print.
Tip: For searches from the Advanced Search page, multiple words are automatically treated as a phrase and find all forms of the words as a phrase.
|
Search Examples |
Finds all records |
|
Note: The best results are frequently found by searching using a CAS Registry Number. |
| * <IN> UsesAndSources |
with a Uses And Sources field |
| sulfuric acid <IN> Name |
with all forms of the word as a phrase in a Name field |
| "sulfuric acid" <IN> Name
|
with the name sulfuric acid in a Name field
|
7664-93-9
7664-93-9 <IN> IdentificationNumber
|
both searches find Sulfuric acid
|
| *h2-o4-s <IN> MolecularFormula
|
with h2-o4-s in a molecular formula
|
| skin sensitization<IN> HealthEffects
|
with all forms of the word as a phrase in Health Effects
|
| Toxicology review <IN> AnimalToxicity
|
with toxicology reviews
|
| aquatic fate <IN> EnvironmentalEffects
|
substances with information on aquatic fate
|
| antimicrobial agent <IN> UsesAndSources
|
substances which are used as antimicrobial agents
|
| LD50 <IN> AnimalToxicity <AND> rat <IN> AnimalToxicity
|
with an LD50 value for rat
|
| LD50 <IN> AnimalToxicity <AND> rat <IN> AnimalToxicity <AND> oral <IN> AnimalToxicity
|
with an oral LD50 value for rat
|
Tip: Brackets have special meaning in searching, therefore, to search for chemical name containing brackets, e.g. Bis(chloromethyl) Ether, use Bis\(chloromethyl)\ Ether.
You can search all the fields in the database. Each field has a specific name which must be used for searching. The table below summarizes the commonly used fields and gives the syntax of the field name to be used for searching:
| Field Name |
Names To Be Used For Searching |
| Name Of Substance |
Name |
| Synonym |
Name |
| CAS Registry Number |
IdentificationNumber |
| Shipping Name Number |
IdentificationNumber |
| Molecular Formula |
MolecularFormula |
| Odor |
AppearanceAndOdour |
Tip: For a complete list of database fields, while viewing a database record, turn on the Field Help from the toolbar and click on the ? help symbol next to the field in any database record. You can now view the field name and its description, from the complete list of fields for the database. You can easily print this list, by clicking in the field help window, right-clicking and then selecting Print.
|
