DeLorme 6 - Manual (Page 185)

Working With GIS
177
MIN MIN( field ) Return the minimum value of a field.
The result type is the same as the
data type of field.
MONTH MONTH( date_expression
)
Returns an integer representing the
month datepart of the specified
date. The result type is
integer_expression.
OR logical_expression OR
logical_expression
Returns TRUE if either of two logical
expressions are TRUE, and FALSE
otherwise. The result type is
logical_expression.
POWER POWER(
numeric_expression ,
power )
Raise a number to a power. power
must be of type integer_expression .
The result type is float_expression.
PREFIX PREFIX( string_expression
, string_expression )
Return TRUE if the first string begins
with the second string, and FALSE
otherwise. The result type is
logical_expression.
REPLACE REPLACE(
string_expression ,
string_expression ,
string_expression )
Returns the string generated by
replacing all occurrences of the
second string expression in the first
string expression with the third
string expression. The result type is
string_expression.
RIGHT RIGHT( string_expression
, number_of_characters )
Return the rightmost
number_of_characters characters of
a string. number_of_characters
must be of type integer_expression.
The result type is string_expression.
RTRIM RTRIM( string_expression
)
Return a string with spaces removed
from its right end. The result type is
string_expression.
ROUND ROUND(
numeric_expression ,
number_of_digits )
Round number to number_of_digits
decimal places to the right of the
decimal point (negative values of
number_of_digits are to the left of
the decimal point). number_of_digits
must be of type integer_expression.
The result type is float_expression.
SQRT SQRT(
numeric_expression )
Returns the square root of a
number. The result type is
float_expression.
STUFF STUFF( string_expression
, start , length ,
string_expression )
Return the string formed by
replacing the length characters of
the first string beginning at start
with the second string. length and