Download Credential Designer - Ber

67
Functions
These built-in functions can be used in expressions. The function names are not
case-sensitive - "DATE()", "Date()" and "date()" are all valid. Some functions
have more than one name, for the convenience of people who are used to the
different names.
String functions
LEFT(s, n) -Return the first n characters of the string s.
Example:
LEFT(First_Name, 1) + LEFT(Last_Name, 1)
RIGHT(s, n) -Return the last n characters of the string s.
Example:
RIGHT(Employee_Number, 3)
LTRIM(s) -Remove blank spaces from the beginning of a string.
Example:
LTRIM(First_Name)
RTRIM(s) -Remove blank spaces from the end of a string.
Example:
RTRIM(First_Name)
LCASE(s), LOWER(s) -Change all the letters in a string to lower-case. LCASE
and LOWER are synonyms.
Example:
LCASE(First_Name)
UCASE(s), UPPER(s) -Change all the letters in a string to upper-case. UCASE
and UPPER are synonyms.
Example:
UCASE(Card_Code)
EPIExpression Syntax - Functions