Hi,
My reqiremnent is :
eno ename sal
100 sssss 29000
150 aaaaa 23456
200 eeeee Null
190 wwwww null
888 nnnnn 4444

In the above source I want to replace sal column Null values with 0(zero).
for this i used derived column Replace function:
i wrote expresion as REPLACE("NULL","NULL","0"). it is not working.
it is replacing total sal column with 0 ( zero).

ss

UPDATE Table1
SET Sal = 0
WHERE Sal IS NULL

UPDATE Table1
SET Sal = 0
WHERE Sal IS NULL