SQL Eval Function String_IndexOfInvariantCultureIgnoreCase

String_IndexOfInvariantCultureIgnoreCase 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 invariant culture, and ignoring the case of the strings.

String_IndexOfInvariantCultureIgnoreCase (
	@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_IndexOfInvariantCultureIgnoreCase('This is a string.', 'string')
SELECT SQLNET::String_IndexOfInvariantCultureIgnoreCase('Archæology', 'Æ')

String_IndexOfInvariantCultureIgnoreCase4k

It is equivalent to String_IndexOfInvariantCultureIgnoreCase 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_IndexOfInvariantCultureIgnoreCase4k (
	@source NVARCHAR (4000), 
	@searchValue NVARCHAR (4000)
	)
RETURNS INT

Example

SELECT SQLNET::String_IndexOfInvariantCultureIgnoreCase4k('This is a string.', 'string')
SELECT SQLNET::String_IndexOfInvariantCultureIgnoreCase4k('Archæology', 'Æ')


Contents