|
![](/web/20061206191557im_/http://ccinfoweb.ccohs.ca/images/blank.gif) |
Help - CHEMpendium Field Searching |
![](/web/20061206191557im_/http://ccinfoweb.ccohs.ca/images/chempendium_lrg.gif) |
|
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. CASRegistryNumber. 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 CHEMpendium Advanced Search page:
Major Search Fields
Search Examples
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
|
HealthEffects |
related to human health and toxic effects
|
AnimalToxicity
|
related to animal health and toxic effects
|
EnvironmentalEffects
|
environmental fate and exposure pontential
|
AppearanceAndOdour
|
appearance and odour
|
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> HealthEffects |
with a Health Effects field |
*ketone <IN> Name |
with ketone as part of the chemical name |
sulfuric acid <IN> Name |
with the word sulfuric and acid in a Name field |
"sulfuric acid" <IN> Name
|
with sulfuric acid in a Name field
|
1,1,1-trichloroethane <IN> Name |
with 1,1,1-tricloroethane in a Name field |
trichloroethane <IN> Name |
with trichloroethane in a Name field |
cancer* <IN> HealthEffects |
that contain words that begin with cancer in the Health Effects field |
grey crystal <IN> AppearanceAndOdour |
with the word grey and crystal in the Appearance And Odour field |
Tip: Brackets have special meaning in searching, therefore, to search for chemical name containing brackets, e.g. Bis(chloromethyl) Ether, use Bis\(chloromethyl)\ Ether.
|