title: How do I cast on an update? The data field is set to vchar(4) and I would like to cast it as an int
body: <p>This is what I have come up with so far but I am getting a syntax error</p>
  
  <pre><code>   update t_Provider set(CAST(f_Postnr as int)) = '66886' where f_Name= 'Test1'
  </code></pre>