eXtremeSQL String Functions

Please use the links in the table below to view the eXtremeSQL string functions:

integer(s)	Returns the value of string expression s converted to integer
length(s)	Returns the length of string expression s
lower(s)	Returns the string expression s converted to lower case
real(s)	Returns the value of string expression s converted to real
string(r)	Returns the string of real value r
sleft(s, n)	Returns the left part of a character string expression s with the specified number of characters n
sright(s, n)	Returns the right part of a character string expression s with the specified number of characters n
substr(s,m[,n])	Returns the substring of s, beginning at character m (1-based), n characters long (if n is omitted, to the end of string)
trim(s)	Removes the leading and trailing spaces from string expression s
upper(s)	Returns the string expression s converted to upper case