SQL Eval Function String_CompareIgnoreCase
String_CompareIgnoreCase
compares two specified String objects, ignoring or honoring their case, and returns an integer that indicates their relative position in the sort order.
String_CompareIgnoreCase ( @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_CompareIgnoreCase('case', 'Case') SELECT SQLNET::String_CompareIgnoreCase('Archæology', 'ARCHÆOLOGY')
String_CompareIgnoreCase4k
It is equivalent to String_CompareIgnoreCase
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_CompareIgnoreCase4k ( @strA NVARCHAR (4000), @strB NVARCHAR (4000) ) RETURNS INT
Example
SELECT SQLNET::String_CompareIgnoreCase4k('case', 'Case') SELECT SQLNET::String_CompareIgnoreCase4k('Archæology', 'ARCHÆOLOGY')