Functions

The following functions are supported by SNQL.

concat
Return the concatenation of all the arguments
text1r
The first text to concatenate
text2
The next text to concatenate
text3...textN
More text to concatenate
lower
Return the argument converted to lower case
textr
The text to convert to lower case
not
Return the logical not of the argument
booleanr
An expression that will be evaluated as boolean.
now
Return the current time as the number of milliseconds since January 1, 1970 UTC
no parameters
rand
Generate a pseudo-random number between 0 and 2^31-1 inclusive
no parameters
strlen
Return the number of characters in text
textr
The text to count the characters in.
strpos
Return the position of the first occurrence of excerpt in text
textr
The text to search for excerpt
excerptr
The excerpt to find the position of
substr
Return a portion of a string
textr
The text to return a portion of
startr
The zero-based position of the first character to include in the result
lengthr
The number of characters to return
upper
Return the argument converted to upper case
textr
The text to convert to upper case