SQL Eval Function String_Compare
String_Compare
compares two specified String objects and returns an integer that indicates their relative position in the sort order.
String_Compare ( @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_Compare('abc', 'abc')
String_Compare4k
It is equivalent to String_Compare
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_Compare4k ( @strA NVARCHAR (4000), @strB NVARCHAR (4000) ) RETURNS INT
Example
SELECT SQLNET::String_Compare4k('abc', 'abc')