SQL Eval Function String

Represents text as a sequence of UTF-16 code units.

Name Description Example
String_Compare(strA, strB) Compares two specified String objects. Try it
String_CompareCurrentCulture(strA, strB) Compares two specified String objects using culture-sensitive sort rules and the current culture. Try it
String_CompareCurrentCultureIgnoreCase(strA, strB) Compares two specified String objects using culture-sensitive sort rules, the current culture, and ignoring the case of the strings. Try it
String_CompareIgnoreCase(strA, strB) Compares two specified String objects ignoring their case. Try it
String_CompareInvariantCulture(strA, strB) Compares two specified String objects using culture-sensitive sort rules and the invariant culture. Try it
String_CompareInvariantCultureIgnoreCase(strA, strB) Compares two specified String objects using culture-sensitive sort rules, the invariant culture, and ignoring the case of the strings. Try it
String_CompareOrdinal(strA, strB) Compares two specified String objects using ordinal (binary) sort rules. Try it
String_CompareOrdinalIgnoreCase(strA, strB) Compares two specified String objects using ordinal (binary) sort rules, and ignoring the case of the strings. Try it
String_Contains(source, target) Returns a value indicating whether a specified substring occurs within this string. Try it
String_EndsWith(source, target) Determines whether the end of the source string instance matches a target string. Try it
String_IndexOf(source, searchValue) Returns the zero-based index of the first occurrence of the specified string. Try it
String_IndexOfCurrentCulture(source, searchValue) Returns the zero-based index of the first occurrence of the specified string using culture-sensitive sort rules and the current culture. Try it
String_IndexOfCurrentCultureIgnoreCase(source, searchValue) Returns the zero-based index of the first occurrence of the specified string using culture-sensitive sort rules, the current culture, and ignoring the case of the strings. Try it
String_IndexOfInvariantCulture(source, searchValue) Returns the zero-based index of the first occurrence of the specified string using culture-sensitive sort rules and the invariant culture. Try it
String_IndexOfInvariantCultureIgnoreCase(source, searchValue) Returns the zero-based index of the first occurrence of the specified string using culture-sensitive sort rules, the invariant culture, and ignoring the case of the strings. Try it
String_IndexOfOrdinal(source, searchValue) Returns the zero-based index of the first occurrence of the specified string using ordinal (binary) sort rules. Try it
String_IndexOfOrdinalIgnoreCase(source, searchValue) Returns the zero-based index of the first occurrence of the specified string using ordinal (binary) sort rules, and ignoring the case of the strings. Try it
String_Insert(source, startIndex, value) Returns a new string in which a specified string is inserted at a specified index position. Try it
String_LastIndexOf(source, searchValue) Returns the zero-based index of the last occurrence of the specified string. Try it
String_LastIndexOfCurrentCulture(source, searchValue) Returns the zero-based index of the last occurrence of the specified string using culture-sensitive sort rules and the current culture. Try it
String_LastIndexOfCurrentCultureIgnoreCase(source, searchValue) Returns the zero-based index of the last occurrence of the specified string using culture-sensitive sort rules, the current culture, and ignoring the case of the strings. Try it
String_LastIndexOfInvariantCulture(source, searchValue) Returns the zero-based index of the last occurrence of the specified string using culture-sensitive sort rules and the invariant culture. Try it
String_LastIndexOfInvariantCultureIgnoreCase(source, searchValue) Returns the zero-based index of the last occurrence of the specified string using culture-sensitive sort rules, the invariant culture, and ignoring the case of the strings. Try it
String_LastIndexOfOrdinal(source, searchValue) Returns the zero-based index of the last occurrence of the specified string using ordinal (binary) sort rules. Try it
String_LastIndexOfOrdinalIgnoreCase(source, searchValue) Returns the zero-based index of the last occurrence of the specified string using ordinal (binary) sort rules, and ignoring the case of the strings. Try it
String_Length(source) Returns the number of characters in the specified string. Try it
String_Occurrences(source, searchValue, isCaseSensitive) Returns the number of occurrences in the specified string. Try it
String_PadLeft(source, totalWidth, paddingChar) Returns a new string that right-aligns the characters in this instance by padding them on the left with a specified Unicode character, for a specified total length. Try it
String_PadRight(source, totalWidth, paddingChar) Returns a new string that left-aligns the characters in this instance by padding them on the right with a specified Unicode character, for a specified total length. Try it
String_Remove(source, startIndex) Returns a new string in which all the characters in the source string, beginning at a specified position are deleted till the end of the source string. Try it
String_RemoveNumOfChars(source, startIndex, count) Returns a new string in which a specified number of characters in the source beginning at a specified position have been deleted. Try it
String_Replace(source, oldValue, newValue) Returns a new string in which all occurrences of a specified Unicode character or String in the current string are replaced with another specified Unicode character or String. Try it
String_Split(source, delimStr) Returns a string array that contains the substrings in this instance that are delimited by elements of a specified string. Try it
String_SplitRemoveEmptyEntries(source, delimStr) Returns a string array that contains the substrings in this instance that are delimited by elements of a specified string and remove elements that contain an empty string. Try it
String_StartsWith(source, target) Determines whether the beginning of this string instance matches a specified string. Try it
String_Substring(source, startIndex, length) Returns a substring from the source string starting at a specified character position and has a specified length. Try it
String_ToLower(source) Returns a copy of this string converted to lowercase. Try it
String_ToLowerInvariant(source) Returns a copy of this string converted to lowercase using the casing rules of the invariant culture. Try it
String_ToTitleCase(source) Converts the specified string to title case (except for words that are entirely in uppercase, which are considered to be acronyms). Try it
String_ToUpper(source) Returns a copy of this string converted to uppercase. Try it
String_ToUpperInvariant(source) Returns a copy of this string converted to uppercase using the casing rules of the invariant culture. Try it
String_Trim(source) Removes all the leading and trailing white-space characters from the source string. Try it
String_TrimChars(source, charsToTrimStr) Removes all the leading and trailing occurrences of a set of characters specified in charsToTrimStr from the source string. Try it
String_TrimEnd(source, charsToTrimStr) Removes all the trailing occurrences of a set of characters specified in charsToTrimStr from the source string. Try it
String_TrimStart(source, charsToTrimStr) Removes all the leading occurrences of a set of characters specified in charsToTrimStr from the source string. Try it