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 |