|
Subject:
|
Replace with 0(zero) Urgent
|
|
Posted By:
|
ssaranam
|
Post Date:
|
4/17/2008 12:53:33 AM
|
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
|
|
Reply By:
|
Peso
|
Reply Date:
|
4/17/2008 1:10:53 AM
|
UPDATE Table1
SET Sal = 0
WHERE Sal IS NULL
|
|
Reply By:
|
bhasker_braj121
|
Reply Date:
|
4/24/2008 6:17:35 AM
|
UPDATE Table1
SET Sal = 0
WHERE Sal IS NULL
|
