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. Envirofacts

Greenhouse Gas Operator Definition

Home | Multisystem Search | Topic Searches | System Data Searches | About the Data | Data Downloads | Widgets| Services | Mobile| Other Datasets
GHG Banner
ghg image

Comparison Operators

The Operator Definition and the Search Value fields allow you to enter specific search criteria to further refine the information that is being selected. The Operator Definition field allows you to specify the scope of the search value that you are entering under the Search Value option.

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 search. 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

USAGE

RETRIEVAL EFFICIENCY

equals

The database will only return rows where the column value is equal to the search value.

Very Good

not equals

The database will only return rows where the column value is NOT equal to the search value.

Very Good

includes

The database will only return rows where the search value is contained within the column value.

Poor

excludes

The database will only return rows where the search value is NOT contained within the column value.

Poor

starts with

For Character fields only. 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

not starts with

For Character fields only. The database will only return rows where the start of column value is NOT equal to the search value. A comparison is done, character by character, up to the last character entered for the search value.

Very Good

ends with

For Character fields only. The database will only return rows where the end 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

not ends with

For Character fields only. The database will only return rows where the end of column value is NOT 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

For numerical fields only. The database will only return rows where the column value is less than the search value.

Very Good

less than or equal to

For numerical fields only. The database will only return rows where the column value is equal to or less than the search value.

Very Good

greater than

For numerical fields only. The database will only return rows where the column value is greater than the search value.

Very Good

greater than or equal to

For numerical fields only. The database will only return rows where the column value is equal to or greater than the search value.

Very Good

in

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 the search values.

Good

Greenhouse Gas Links

  • Overview
  • Search
    • Search User Guide
  • Query Builder (formerly Customized Search)
    • Customized Search User Guide
    • Operator Definition
  • RESTful API
  • Model
  • Metadata Search
  • Greenhouse Gas Reporting Program
  • Greenhouse Gas Equivalencies Calculator

System Data Searches

  • Multisystem
  • BR
  • Brownfields/Cleanups
  • Cleanups
  • ECHO/IDEA
  • FRS
    • EZ Search
    • Organization Search
  • Greenhouse Gas
    • Customized Search
  • ICIS
  • ICIS-AIR
  • ICR
  • NGGS
  • 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
  • UV Index

Other Sites of Interest

  • Geospatial Download
  • EnviroMapper
  • MyEnvironment
Contact Us to ask a question, provide feedback, or report a problem.
Last updated on September 6, 2024
  • 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.