Download Report Studio User Guide

Appendix D: Using the Expression Editor
Syntax
left ( string_exp, integer_exp )
length
Returns the length of the operand in bytes (except for double byte string types which return the
length in characters).
Syntax
length ( exp )
locate
Returns the starting position of the first occurrence of string_exp1 within string_exp2. The search
starts at position start (integer_exp) of string_exp2. The first character in a string is at position 1.
If string_exp1 is not found then zero is returned.
Syntax
locate ( string_exp1, string_exp2 [ , integer_exp ] )
long_varchar
Returns a long string.
Syntax
long_varchar ( string_exp )
ltrim
Returns string_exp with leading spaces removed.
Syntax
ltrim ( string_exp )
microsecond
Returns the microsecond (time-unit) part of a value. exp can be a timestamp or a string
representation of a timestamp.
Syntax
microsecond ( exp )
midnight_seconds
Returns an integer value in the range 0 to 86400 representing the number of seconds between
midnight and time value specified in the argument. exp can be a time value, a timestamp or a
string representation of a time.
Syntax
midnight_seconds ( exp )
minute
Returns the minute (an integer from 0-59) from time_exp. time_exp can be a time value, a
timestamp or a string representation of a time.
Syntax
minute ( time_exp )
month
Returns the month (an integer from 1-12) from date_exp.
User Guide 271