comparing two strings in SQL server
Is there any way to compare two strings in SQL server 2008 stored procedure like below?

<br>
int returnval = STRCMP(str1, str2)
<br>
  

 - returns 0 if the strings are
   the same.<br>
 - returns -1 if the first
   argument is smaller than the second
   according to the current sort order.
 - returns 1 otherwise.

above method i find in the MySQL but not in SQLServer.
comparing two strings in SQL server
===

Is there any way to compare two strings in SQL server 2008 stored procedure like below?

<br>
int returnval = STRCMP(str1, str2)
<br>
  

 - returns 0 if the strings are
   the same.<br>
 - returns -1 if the first
   argument is smaller than the second
   according to the current sort order.
 - returns 1 otherwise.

above method i find in the MySQL but not in SQLServer.