Text Functions

Function result = charindex(needle, haystack, [start]) Arguments Argument Data Type needle string haystack string start integer result integer Comments This function searches for the needle  string , in the haystack...

Returns the number of characters in the input string. Function result = len(input) Arguments Argument Data Type input string result integer Comments If the string is a rich-text string then this will be inclusive of HTML for...

Returns the specified number of characters from the start of a text value. Function result = left(text, count) Arguments Argument Data Type text string count integer result string Examples result = left('Falcon Heavy', ...

Generates a new globally unique identifier (GUID). Function result = newguid() Arguments Argument Data Type result string Comments Generates a new globally unique identifier as a string, without braces. The newguid function i...

Performs a search and replace over some text and returns the result. Function result = replace(text, find, replace) Arguments Argument Data Type text string find string replace string result string Comments Finds fi...

Returns to specified number of characters from the end of a text value. Function result = right(text, count) Arguments Argument Data Type text string count integer result string Examples result = right('Falcon Heavy', 5...

Returns a sub portion of a text value. Function result = substring(text, start, count) Arguments Argument Data Type text string start integer count integer result string Comments Clips a string, beginning at the star...

Converts the input text to lowercase. Function result = tolower(input) Arguments Argument Data Type input string result integer Comments Text values should not be converted to upper or lower case for the sole purpose of comp...

Converts the input text to uppercase. Function result = toupper(condition) Arguments Argument Data Type input any result any Comments Text values should not be converted to upper or lower case for the sole purpose of compari...