title: Compare password of webpages_membership in SQL Server query
body: <p>I have a web application done in ASP.NET MVC 4. It has users, that are stored in SQL Server database in tables <code>webpages_UserProfile</code> and <code>webpages_Membership</code>, etc.</p>
  
  <p>I have another application, and what I need to do is to query the table <code>webpages_Membership</code>, where password of users are stored encrypted, and compare them to a plain text password.</p>
  
  <p>So I tried doing something like </p>
  
  <pre class="lang-sql prettyprint-override"><code>SELECT * 
  FROM webpages_Membership 
   WHERE PwdCompare('mypasswordsend', Password) = 1
  </code></pre>
  
  <p>But it doesn't works. I know the column is a <code>nvarchar(128)</code>.</p>
  
  <p>How can I compare it?</p>