Filter
Top Products
XMap User Guide
178
start must be of type
integer_expression. The result type
is string_expression.
SUBSTRING SUBSTRING(
string_expression , start ,
length )
Return the length characters of a
string beginning at start.
SUBSTRING is synonymous with the
MID function. length and start must
be of type integer_expression. The
result type is string_expression.
SUFFIX SUFFIX( string_expression
, string_expression )
Return TRUE if the first string ends
with the second string, and FALSE
otherwise. The result type is
logical_expression.
SUM SUM( field ) Return the sum of the values of a
numeric field. The result type is the
same as the data type of field.
UPPER UPPER( string_expression
)
Returns a string with its letters
converted to uppercase. The result
type is string_expression.
YEAR YEAR( date_expression ) Returns an integer representing the
year datepart of the specified date.
The result type is
integer_expression.
+ numeric_expression +
numeric_expression
Returns the result of adding one
number to another. If either of the
expressions is floating point, then
the result type is floating point;
otherwise the result type is integer.
- numeric_expression -
numeric_expression
Returns the result of subtracting one
number from another. If either of
the expressions is floating point,
then the result type is floating point;
otherwise the result type is integer.
* numeric_expression *
numeric_expression
Returns the result of multiplying one
number by another. If either of the
expressions is floating point, then
the result type is floating point;
otherwise the result type is integer.
/ numeric_expression /
numeric_expression
Returns the result of dividing one
number by another. If either of the
expressions is floating point, then
the result type is floating point;
otherwise the result type is integer.
% numeric_expression %
integer_expression
Returns the remainder of dividing
one number by an integer. If the
first expression is floating point,