title: SQL how do I remove trailing spaces?
body: <p>I'm currently working in an SQL database where a column has trailing spaces.</p>
  <p>The spaces in question show up as %20 in the browser url.</p>
  <p>I've been able to remove them with a select query but whenever I convert it to an update an set query it doesn't seem to work, any input would be appreciated.</p>
  <p>Working select query:</p>
  <pre><code>select [dbo].[udf-Str-Strip-Control](identifier)
  from [AHDRC].[dbo].[artworks]
  </code></pre>
  <p>Broken update query:</p>
  <pre><code>update [AHDRC].[dbo].[artworks]
  SET [identifier] = [dbo].[udf-Str-Strip-Control](identifier);                                         
  
  SELECT [identifier]
  From [AHDRC].[dbo].[artworks];
  </code></pre>
  <p>I am currently using SQL server management studio
  [identifier] is a nchar(128)</p>
  <p>Apologies if anything is unclear / badly formatted.</p>