|
![](/web/20061206191656im_/http://ccinfoweb.ccohs.ca/images/blank.gif) |
Help - RTECS Field Searching |
![](/web/20061206191656im_/http://ccinfoweb.ccohs.ca/images/rtecs_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 RTECS® 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
|
Chemical Name
Synonyms and Trade Names
|
IdentificationNumber
|
RTECS Number
CAS Registry Number
Beilstein Reference Number
Beilstein Handbook Number
|
MolecularFormula
|
Molecular Formula
|
HealthEffects |
All toxicity data and toxicity reviews
|
AnimalToxicity
|
All toxicity data and toxicity reviews
|
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 |
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
|
7664-93-9
7664-93-9 <IN> IdentificationNumber
|
both searches find sulfuric acid
|
OEL-United Kingdom
|
with substances assigned an occupational exposure limit (OEL) in the United Kingdom
|
LD50 <IN> HealthEffects < NEAR > mouse <IN>
HealthEffects
|
with an LD50 value for mouse
|
*h2-o4-s <IN> MolecularFormula
|
with h2-o4-s in a molecular formula
|
"IARC Cancer Review:Group 1"
|
substances evaluated as Group 1: carcinogenic to humans in the IARC Monographs
|
reproductive <IN> HealthEffects
|
with reproductive data
|
"Toxicology review" <IN> AnimalToxicity
|
with toxicology reviews
|
severe <IN> SkinEyeReactionSeverity
|
substances producing severe eye and/or skin irritation.
|
2003* <IN> LastUpdated |
with 2003/_ _ in Last Updated; all records added or revised in the year 2003 |
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 |
CAS Registry Number |
CASRegistryNumber |
CAS Registry Number |
IdentificationNumber |
RTECS Number |
IdentificationNumber |
Molecular Formula |
MolecularFormula |
Chemical Name |
ChemicalName |
Last Updated |
LastUpdated |
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.
|