Click here

Boolean operator

There are five Boolean operators that can be used to manipulate TRUE/FALSE values. These operators have the following meanings, where x and y represent values of TRUE or FALSE.

The OR operator is often called an inclusive OR, whereas XOR is an exclusive OR.

Boolean operators are used widely in programming and also in forming database queries. For example, the query

SELECT ALL WHERE LAST_NAME = "Smith" AND FIRST_NAME = "John"

finds all records with the name John Smith. But the query

SELECT ALL WHERE LAST_NAME = "Smith" OR FIRST_NAME = "John"

finds all records with the last name "Smith" or the first name "John."



Top Terms
  • 1

    enterprise application

    An enterprise application is the term used to describe applications -- or software -- that a business would use to assist the organization in...

    Read more »

  • 2

    open source

    Generically, open source refers to a program in which the source code is available to the general public for use and/or modification from its...

    Read more »

  • Click Here!

Connect with Webopedia

Did You Know? Archive »

  • Quick Reference Archive »