expression

Topic group Related topics

A dBL expression of up to 220 characters that includes field names, operators, or functions.

Property of

Dbfindex

Description

A simple index expression consists of a single field, such as "lastname", whereas complex index expressions use a combination of one or more field names, plus valid dBL operators and functions. When creating complex expressions you must first convert all fields to the same data type. Most multi-field expressions are character type; numeric and date fields can be converted to strings using the STR( ) and DTOS( ) functions. When using the STR( ) function, be sure to specify a length for the resulting string which matches the numeric field.