Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ceema
Yak Posting Veteran
80 Posts |
 Posted - 2007-01-17 : 01:39:10
|
| I have a table SIM_TempCustomer where I have 5 fileds nad Values LikeSIM_TempCustomer----------------Val1.........Val2.........Val3.........Val4.........Val5---------------------------------------------------------A.............NUll........1.............Null.........3B.............Null........Null..........Null.........2C.............Null........6.............12...........NullWhat I want i, if there is any value in any fields, other null valuesin the field should be replaced by 0, if all the rows of the filedare null, simply leave as it is....Like the select statement of this SIM_TempCustomer should give a result likeVal1.........Val2.........Val3.........Val4.........Val5---------------------------------------------------------A.............NUll........1.............0............3B.............Null........0.............0............2C.............Null........6.............12...........0Could any one help me.ThanksCeema |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
|
|
|
|
|
How to form this query