SQL Eval Function String_IndexOfCurrentCultureIgnoreCase
String_IndexOfCurrentCultureIgnoreCase
returns the zero-based index of the first occurrence of a searchValue
Unicode character or string within the source
string using culture-sensitive sort rules, the current culture, and ignoring the case of the strings.
String_IndexOfCurrentCultureIgnoreCase ( @source NVARCHAR (MAX), @searchValue NVARCHAR (MAX) ) RETURNS INT
Parameters
- source: The source string.
- searchValue: The string to search within the source string.
Returns
The zero-based index position of the searchValue
parameter from the start of the source
string if that string is found, or -1 if it is not. If searchValue
is Empty, the return value is 0.
Example
SELECT SQLNET::String_IndexOfCurrentCultureIgnoreCase('This is a string.', 'string') SELECT SQLNET::String_IndexOfCurrentCultureIgnoreCase('Archæology', 'Æ')
String_IndexOfCurrentCultureIgnoreCase4k
It is equivalent to String_IndexOfCurrentCultureIgnoreCase
except no NVARCHAR(MAX) parameters; it can be used when input data will never be over 4000 characters as this function offers better performance.
String_IndexOfCurrentCultureIgnoreCase4k ( @source NVARCHAR (4000), @searchValue NVARCHAR (4000) ) RETURNS INT
Example
SELECT SQLNET::String_IndexOfCurrentCultureIgnoreCase4k('This is a string.', 'string') SELECT SQLNET::String_IndexOfCurrentCultureIgnoreCase4k('Archæology', 'Æ')