# 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