sql server replace query?

• monafatima86

  SSC Rookie

  Points: 33

  More actions

  September 24, 2013 at 2:42 pm

  #395542

  I have a column in sql server table in which there are integer values, now i want to replace a range e.g values> 50 with a string 'good' and values<50 replace with 'bad' in only one column in that table, I have tried this

  SELECT t.ColA, CASE WHEN t.ColA >= 50 THEN 'Normal value' WHEN t.ColA < 50 THEN 'abnormal value' END

  FROM MySchema.MyTable AS t

  but it only selects, not replaced the column values>50 with 'normal value' string. any help please?

• Koen Verbeeck

  SSC Guru

  Points: 259085

  More actions

  September 24, 2013 at 2:49 pm

  #1652890

  Maybe you should try an UPDATE statement instead?

  Also make sure ColA is a varchar column, otherwise you won't be able to store the string values.

  (and convert ColA to int before you compare it with 50)

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP