Converting cells with string value ''NULL''

• Mark Green

  SSCrazy

  Points: 2085

  More actions

  August 24, 2006 at 6:05 am

  #114101

  Is there a quick and simple way over converting cells with the string value 'NULL' into cells with the real < NULL > status.  I want to do this to all cells in a table.

• David Burrows

  SSC Guru

  Points: 65142

  More actions

  August 24, 2006 at 6:42 am

  #656548

  NULLIF(cell,'NULL')

  Out of curiosity, what does the table's DDL look like and how do you wish to update the table, eg update query, EM

  Far away is close at hand in the images of elsewhere.
  Anon.