String Functions

 

Operator

Parameter types

Result

StrLen(x)

x - string

Length of x in characters

SubString(x,offset,length)

x - string

offset - integer

length - integer

Returns the substring of x starting at the offset position and the length specified in length.

ToLower(x)

x - string

Converts x to lowercase

ToUpper(x)

x - string

Converts x to uppercase

Trim(x)

x - string

Trims spaces from both sides of the string

x Contains y

x, y - string

Returns all y that contains x