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

Vangie Beal
Vangie Beal
Vangie Beal is a freelance business and technology writer covering Internet technologies and online business since the late '90s.

Related Articles

ScalaHosting

ScalaHosting is a leading managed hosting provider that offers secure, scalable, and affordable cloud VPS solutions for businesses. It claims to change the status...

Data Lake

A data lake is a storage space for all forms of data in an organization, whether raw or processed, structured or unstructured.

Resume

A resume is a formal document created and used by a person to show their career background and skills. Resumes are used for a...

Web Hosting

Web hosting makes a web server available to businesses with varying degrees of provider management. Customers host their websites on the internet through the...

ScalaHosting

ScalaHosting is a leading managed hosting provider that offers secure, scalable, and affordable...

HRIS

Human resources information system (HRIS) solutions help businesses manage multiple facets of their...

Best Managed Service Providers...

In today's business world, managed services are more critical than ever. They can...