** No Messages **
Click here for Instructions in How to use this Tool
General Search  (Leave blank to select ALL Establishments or enter partial or full Establishment Name/Number)
Establishment Name:  
  Establishment Number:    

Search By Establishment Specifications
Food/Day Care:  
Establishment Type:  
Food Ethnic Group:  
Search By Address (Try entering the address number or the street name alone to narrow your search)
Postal Code:  
By default, the Search routine looks for all Establishments and produces a listing of the selected records that match the criteria. In order to narrow your selection, option boxes are provided.  By selecting one or more of these options, the Search looks for content only within the selected content set.
Alphanumeric ValuesNumeric ValuesDates (MM/DD/YYYY)Missing Data
Searching Alphanumeric Values (Strings)
Criteria Example (Enter in Box) Returns all records
Equal To Smith with equal values to Smith (Automatic default)
Begins With Smith% that begins with Smith
Ends With %Smith that ends with Smith
Contains %Smith% that contains the character(s) Smith anywhere in the data
Or ('Smith','Simpson') that are equal to Smith or Simpson
Between Values between 'Sm' and 'Sz' that are greater or equal than 'Sm' and less or equal to 'Sz'

*One space between operator and next character. Operators are "=", "IN", "<", ">", "<>", "BETWEEN"