title: Postgres removing a set of text from a column but keep the remaining text
body: <p>I am trying to find a way of bulk removing the word null from a particular column.</p>
  <p>At present we have a column that has a set of numbers and then the word null afterwards.</p>
  <pre><code>043 null
  00 null
  1 null
  1 null
  1 null
  1 null
  10 null
  10 null
  103 null
  11 null
  11 null
  1102/133 null
  114 null
  </code></pre>
  <p>I am looking for a way of removing the word null from this column but keep the rest as is.</p>
  <p>Whats the most efficient way of doing this? I am using postgresql 12.</p>