Replace value in SQL Table

Question

I like to replace a 'NULL' value in FG_NFG_Selektion column but only in those row where Plant='935S'

Tried:

UPDATE [Table] SET [FG_NFG_Selektion] = REPLACE([FG_NFG_Selektion], 'NULL', 'FG') WHERE [Plant] = '935S'

Message back: 10000 rows affected but still the same 'NULL' is there in the table.

‘Null’ is not the same as null and you don’t need replace — P.Salmon
– P.Salmon, Commented Feb 19, 2020 at 16:50

farhankureshi71 · Accepted Answer · 2020-02-19 16:28:34Z

1

Try with following query

UPDATE [Table] SET `FG_NFG_Selektion` = 'FG' WHERE `Plant` = '935S' AND `FG_NFG_Selektion` IS NULL;

answered Feb 19, 2020 at 16:28

farhankureshi71

4462 silver badges6 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

IS NULL will use to check for the null values in SQL.

Also, do not forget to replace your actual table name with [Table]