title: How to use Collate function in Update query
body: <p>I have an application with Entity Framework and my database collation is:</p>
  
  <pre><code>Latin1_General_CI_AS
  </code></pre>
  
  <p>but my client's database is <code>Georgian_Modern_Set_CI_AS</code>. This is a big problem for us but we solved this problem with 'collate' function. We collate our nvarchar values with <code>Latin1_General_CI_AS</code> such as;</p>
  
  <pre><code>-- with this function we can easily select the data and get into our application.
  select Name collate Latin1_General_CI_AS as Name from Users 
  </code></pre>
  
  <p>But i have some Update statements and I just want to ask how to use 'collate' function in Update query??</p>
  
  <p>Do you have any ideas?</p>
  
  <p>Thanks</p>