asranantha (10/19/2013)

---

Hi friends i have small doubt in sql server how to update nulls and empty values and replac other values in sql server

table data look like below

table :emp

id ,name ,sal ,deptno

1 ,abc ,1oo ,10

2 ,venu ,2000 ,null

3 ,null , ,20

4 ,balu ,null ,

5 ,hari , ,30

based on above table i want output like below

id , name ,sal ,deptno

1 , abc ,100 ,10

2 , venu ,2000 ,NA

3 , NA , NA ,20

4 , balu ,NA ,NA

5 , hari ,NA ,30

plese tell me how to write query while achive in above issuse useing update query

actualy i tried like below query but its not give above exactly result

update emp set name=(case isnull(name,'NA') when '' then 'NA'else name end),

sal =(case isnull(sal,'NA')when '' then 'NA' else sal end) ,

deptno=(case isnull(desptno,'NA') when '' then 'NA' else deptno end)

from emp.

here its not given exactely output.plese tell me update query in sql server.