title: comparing two strings in SQL Server
body: <p>Is there any way to compare two strings in SQL Server 2008 stored procedure like below?</p>
  
  <pre><code>int returnval = STRCMP(str1, str2)
  </code></pre>
  
  <ul>
  <li>returns 0 if the strings are the same</li>
  <li>returns -1 if the first argument is smaller than the second according to the current sort order.</li>
  <li>returns 1 otherwise.</li>
  </ul>
  
  <p>Above method I find in the MySQL but not in SQL Server.</p>