The name-game can be avoided in the unlikely event that you know the CAS (Chemical Abstract) number, as you can search for that as well.
For example here are parts of the line for sugar
Product Company Room Storage Class HMIS CAS Number Sucrose Fisher 205 RT LH 011 57-50-1QuickSearch will seek matches from any and all parts of this line.
A QuickSearch using sucrose produces four hits for four different bottles of sugar in different rooms, from different companies, etc.
A QuickSearch using rose produces nine hits: in addition to the four sucrose hits, 5 hits from Dextrose and Agarose appear.
A QuickSearch using 011 (the HMIS number) produces 18 hits. 15 of these are in fact HMIS 011 (a low hazard), one with a CAS number of 10114-58-6, and two with (undisplayed) MSDS date match (e.g., 19901105).
(Your hit results may differ from those above: the database changes!)
Once you've found the chemical, you may be interested in what all the codes mean. Ckeck out the below for information on HMIS, rooms, storage, class, and companies.
OK, why this "type no spaces!" thing? Well it turns out that a single space is not always the sign of word seperation. For example it's:
Formaldehyde, 37%in this version of the database. (that's: comma space space). Thus QuickSearch uses space (and I only tell this to you folks who read the help documents) for AND, so chlor acid will hit Hydrochloric acid, 37%, Trichloroacetic acid and Glutamic acid hydrochloride, L-.