All | Returns true if all the values specified in its list argument exist in the values argument. |
Any | Returns true if at least one value from the list exists in the values. |
Begins | Returns true if the text u begins with the text v; otherwise, returns false. |
Concat | This function returns a string that results from the concatenation, or joining, of two or more string values in an end-to-end manner. |
Contains | Returns true if text u contains text v; otherwise, returns false. |
Ends | Returns true if the text u ends with the text v, otherwise returns false. |
Guid | Returns a unique string in the XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX format, where each X represents a character from the 0123456789ABCDEF character set. |
Left | Returns the left part of a text value. |
Len | Returns the number of characters in a text. |
List | Concatenates all value arguments starting with the second argument, using the first argument as a delimiter between them. |
Lower | Returns text converted to lowercase. |
Mid | Returns a specific number of characters from a text string, starting at the position you specify, based on the number of characters you specify. |
NotLeft | Returns what remains after excluding the left part of a text value. |
NotRight | Returns what remains after excluding the right part of a text value. |
PadLeft | Right-aligns the characters in the string by padding them on the left to achieve a specified total length. |
PadRight | Left-aligns the characters in the string by padding them on the right to achieve a specified total length. |
Part | Returns the specified part of a text value. The parts are separated by the occurrence of any delimiter character. |
Proper | Capitalizes the first letter in the text and any other letters in the text that follow any character other than a letter. Converts all other letters to lowercase letters, except for words that are entirely in uppercase, which are considered to be acronyms. |
Replace | Replaces substrings containing the old text with the new text in the given text. |
Right | Returns the right part of a text value. |
Trim | Returns text with leading and trailing white space characters removed. |
Upper | Returns text converted to uppercase. |
URLEncode | Encodes a URL string. |
URLDecode | Converts a URL-encoded string into a decoded string. |
URLParam | Extracts and decodes the value of a parameter from a URL’s query string. |