image\Dql_0023.gifConstant Value

Type

Concept

Purpose

A constant value is a value that does not change while a procedure is being processed (in contrast to a variable, a value that can change during processing).

Constant values are used in selection criteria comparisons, math formulas, proper names, and other text and numeric expressions.

Usage

In a script, a constant value can be used wherever its value type is allowed. The value types of constants are the same as the basic field value types: text, number, numeric string, date, time, and dollar.

The format for typing constant values is as follows:

 

Example

for MEMBERS with LAST NAME = " SPENCER "

and ZIP CODE > 90000 ;

 

In this query statement, both the last name SPENCER and the zip code 90000 are constant values.