Contains()

Text

Determines if a search string is included in an input string

Instr()

Text

Returns the position of a search string in an input string, starting from the left

Left()

Text

Returns the leftmost characters in a string

Length()

Text

Returns the number of characters in a string

Lfind()

Text

Returns the position of a search string in an input string, starting from the left

Lower()

Text

Converts all characters in a string to lowercase

Lpad()

Text

Adds characters or spaces to the left side of a character string

Ltrim()

Text

Removes characters or spaces from the left side of a character string

Proper()

Text

Converts the first character each part of a string to uppercase and all other characters to lowercase

Regexp()

Text

Returns a portion of a string that matches the regular expression given by the match string

Repeat()

Text

Repeats the characters in a string for a specified length

Replace()

Text

Replaces each occurrence of a search string in an input string with another string

Reverse()

Text

Reverses the order of characters in a string

Rfind()

Text

Returns the position of a search string in an input string, starting from the right

Right()

Text

Returns the rightmost characters in a string

Rpad()

Text

Adds characters or spaces to the right side of a character string

Rtrim()

Text

Removes characters or spaces from the right side of a string

Soundex()

Text

Returns a phonetic representation of a string

Strpart()

Text

Returns the nth section of an input string

Substr()

Text

Returns a portion of an input string

Translate()

Text

Replaces each character in a string with a corresponding character in a search list with a character from a replace list

Trim()

Text

Removes characters from the left and right sides of an input string

Upper()

Text

Converts all characters in a string to uppercase