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 |
|
rwlopez
Yak Posting Veteran
80 Posts |
 Posted - 2006-10-24 : 14:32:49
|
| Is there a way to treat Null Values as a Zero?For example Null + 1 = 1Rather than Null + 1 = Null |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-10-24 : 14:51:05
|
| Use ISNULL function.Tara Kizer |
 |
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2006-10-24 : 15:13:25
|
| How do you define NULL as 0, is this an outer join?____________________I have null problemsrockmoose |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-10-24 : 23:07:37
|
| >>___________________I have null problemsRocky, I like your topic level signaturerwlopez, read about ISNULL function in sql server help fileYou may need to useSelect ISNULL(col,0)+1 from tableMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Null Values