Wednesday, February 15, 2012

Empty Field Query

Hi Friends,

I have one query that i have to Replace the Empty Value of a filed with some other value how can i do in SQL??

ID Phone Name
1 122 abc
2 xyz
3 444 mmm
4 525 ccc
5 nvb

Now i want replace the blank (Empty) filed with some charaters Numbers how can i do that?? any Help

Ashu


Case [Name]
When '' Then 'Empty'
Else [Name]
End

No comments:

Post a Comment