Predicate (SQL)

Help Contents

Introduction

An SQL Predicate performs a logical test and returns either TRUE, FALSE, or UNKNOWN.

Syntax

predicate ::=
  comparison-predicate
  | between-predicate
  | exists-predicate
  | in-predicate
  | null-predicate
  | like-predicate
  | quantified-comparison-predicate

Remarks

Predicates perform a logical test on one or more values.

Further Information

Fernhill SCADA Structured Query Language (SQL)

To learn more about the SQL features in Fernhill SCADA.

Glossary

For the meaning of terms used in Fernhill SCADA.