SQL Eval Function String_CompareCurrentCultureIgnoreCase
String_CompareCurrentCultureIgnoreCase
compares two specified String objects using culture-sensitive sort rules, the current culture, and ignoring the case of the strings, and returns an integer that indicates their relative position in the sort order.
String_CompareCurrentCultureIgnoreCase ( @strA NVARCHAR (MAX), @strB NVARCHAR (MAX) ) RETURNS INT
Parameters
- strA: The first string to compare.
- strB: The second string to compare.
Returns
A 32-bit signed integer that indicates the lexical relationship between the two comparands.
Value | Condition |
---|---|
Less than zero | strA precedes strB in the sort order. |
Zero | strA occurs in the same position as strB in the sort order. |
Greater than zero | strA follows strB in the sort order. |
Example
SELECT SQLNET::String_CompareCurrentCultureIgnoreCase('case', 'Case') SELECT SQLNET::String_CompareCurrentCultureIgnoreCase('encyclopædia', 'encyclopaedia')
String_CompareCurrentCultureIgnoreCase4k
It is equivalent to String_CompareCurrentCultureIgnoreCase
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_CompareCurrentCultureIgnoreCase4k ( @strA NVARCHAR (4000), @strB NVARCHAR (4000) ) RETURNS INT
Example
SELECT SQLNET::String_CompareCurrentCultureIgnoreCase4k('case', 'Case') SELECT SQLNET::String_CompareCurrentCultureIgnoreCase4k('encyclopædia', 'encyclopaedia')