Skip to main content
U.S. flag

An official website of the United States government

Here’s how you know

Dot gov

Official websites use .gov
A .gov website belongs to an official government organization in the United States.

HTTPS

Secure .gov websites use HTTPS
A lock (LockA locked padlock) or https:// means you’ve safely connected to the .gov website. Share sensitive information only on official, secure websites.

    • Environmental Topics
    • Air
    • Bed Bugs
    • Cancer
    • Chemicals, Toxics, and Pesticide
    • Emergency Response
    • Environmental Information by Location
    • Health
    • Land, Waste, and Cleanup
    • Lead
    • Mold
    • Radon
    • Research
    • Science Topics
    • Water Topics
    • A-Z Topic Index
    • Laws & Regulations
    • By Business Sector
    • By Topic
    • Compliance
    • Enforcement
    • Laws and Executive Orders
    • Regulations
    • Report a Violation
    • Environmental Violations
    • Fraud, Waste or Abuse
    • About EPA
    • Our Mission and What We Do
    • Headquarters Offices
    • Regional Offices
    • Labs and Research Centers
    • Planning, Budget, and Results
    • Organization Chart
    • EPA History

Breadcrumb

  1. Home
  2. Facility Registry Service (FRS)

EZ Query Search Options Help

2025 Update

EZ Query is currently offline and being migrated to a new service. Use the FRS Query as an alternative until the migration is complete.

Search Options Help

In database terms, the Search Options are really "comparison operators". What they do is compare the database column value against the search value that you've entered from the Query Form. Based on the comparison, the database will either accept the row for processing or it will reject the row. Explanations for each operator are given below:

OPERATOR USEAGE RETRIEVAL EFFICIENCY
Equal to The database will only return rows where the column value is equal to the search value. Very Good
Not Equal to The database will only return rows where the column value is NOT equal to the search value. Very Good
Beginning with The database will only return rows where the start of column value is equal to the search value. A comparison is done, character by character, up to the last character entered for the search value. Very Good
Less than/Equal to The database will only return rows where the column value is equal to or less than the search value. Very Good
Greater than/Equal to The database will only return rows where the column value is equal to or greater than the search value. Very Good
Less than The database will only return rows where the column value is less than the search value. Very Good
Greater than The database will only return rows where the column value is greater than the search value. Poor
Containing For Character fields only. The database will only return rows where the search value is contained within the column value. As an example if the search value entered is "ABC" and the column value is "CCABCDD" then the row will be accepted. Using the same search value of "ABC" if the column value was "AABBCC" then the row will be rejected. Good
in A very powerful operator for Character fields only. Instead of a single search value, the user can enter multiple search values, each separated by a comma. The database will only return rows where the column value is equal to one of search values. As an example if the search value entered is "CCAA, AABB, CCAB" and the column value is "CCAB" then the row will be accepted. Using the same search value of "CCAA, AABB, CCAB" if the column value was "CCBB" then the row will be rejected. Average
Not in The Opposite of the "In" operator. Instead of a single search value, the user can enter multiple search values, each separated by a comma. The database will only return rows where the column value is not equal to one of search values. As an example if the search value entered is "CCAA, AABB, CCAB" and the column value is "CCAB" then the row will be rejected. Using the same search value of "CCAA, AABB, CCAB" if the column value was "CCBB" then the row will be accepted. Good
Between Instead of a single search value, the user enters a starting and an ending search value, separated by the literal "AND". The database will only return rows where the column value is equal to or greater than the starting search value and less than or equal to the ending search value. As an example if the search value entered is "60085 and 60087" and the column value is "60085" then the row will be accepted. Using the same search value of "60085 and 60087" if the column value was "60088" then the row will be rejected. To aid the user, a pop-up window is displayed which will automatically insert the "AND" literal. Good

Facility Registry Service Links

  • Facility Registry Service (FRS) Overview
  • Geospatial Overview
  • Office of Information Management (OIM)

System Data Searches

  • Multisystem
  • BR
  • Brownfields/Cleanups
  • Cleanups
  • ECHO/IDEA
  • FRS
    • EZ Search
    • Organization Search
  • Greenhouse Gas
    • Customized Search
  • ICIS
  • ICIS-AIR
  • ICR
  • Locational Information
    • Locational Search
  • NEI
  • PCS
    • Customized Search
  • RadNet
    • Customized Search
  • RCRAInfo
  • SDWIS
  • SEMS
  • SRS
  • TRI
    • TRI Explorer
    • TRI Search
    • Form R Search
    • Form R & A Download
    • EZ Search
    • Customized Search
    • Pollution Prevention
  • TSCA
  • UV Index

Other Sites of Interest

  • Geospatial Download
  • EnviroMapper
  • MyEnvironment

Facility Registry Service (FRS)

  • FRS Home
  • Search for FRS data
    • FRS Query
      • FRS Query Form's User Guide
    • Enforcement and Compliance History Online
    • Envirofacts Multisystem Search
      • Envirofacts Data Service API
    • Geospatial Data Download Options
    • FRS Query Builder
  • FRS Description
    • FRS Physical Data Model
    • FRS Data Sources
      • FRS Data Resource Updates Dashboard
    • FRS Data Dictionary
    • FRS API
  • Facility Linkage Application (FLA)
    • Data Steward Resources
      • FLA Best Practices
      • FLA Training
Contact Us About FRS
Contact Us About FRS to ask a question, provide feedback, or report a problem.
Last updated on March 25, 2025
  • Assistance
  • Spanish
  • Arabic
  • Chinese (simplified)
  • Chinese (traditional)
  • French
  • Haitian Creole
  • Korean
  • Portuguese
  • Russian
  • Tagalog
  • Vietnamese
United States Environmental Protection Agency

Discover.

  • Accessibility Statement
  • Budget & Performance
  • Contracting
  • EPA www Web Snapshot
  • Grants
  • No FEAR Act Data
  • Plain Writing
  • Privacy
  • Privacy and Security Notice

Connect.

  • Data
  • Inspector General
  • Jobs
  • Newsroom
  • Regulations.gov
  • Subscribe
  • USA.gov
  • White House

Ask.

  • Contact EPA
  • EPA Disclaimers
  • Hotlines
  • FOIA Requests
  • Frequent Questions
  • Site Feedback

Follow.