User`s guide
uUpper, uUpp
186 Sybase IQ ETL 4.1
uTrim(" 3.5 ") // returns "3.5"
uTrim("003.500", "0") // returns "3.5"
uUpper, uUpp
Description Returns the input string in uppercase letters
Syntax string uUpper(input)
Parameters
string input
The input string.
Examples To convert a string into uppercase letters:
uUpper("James T. Kirk") // returns "JAMES T. KIRK"
Operator functions
uEQ
Description Returns 1 if both parameters are equal and no parameter is NULL.
Syntax number uEQ(value1, value2)
Parameters
value1, value 2
Numeric or string values to compare.
Examples uEQ(1,2) // returns 0
uEQ(1,1) // returns 1
uEQ(null,1) // returns 0
uNE
Description Returns 1 if both parameters are not equal and no parameter is NULL.