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 |
|
olay80
Yak Posting Veteran
62 Posts |
 Posted - 2005-07-28 : 04:48:27
|
| hey guys,i need to change a NULL value as it occures while executing the sql to 0. what function do i use?thanx,Oliver |
|
|
ditch
Master Smack Fu Yak Hacker
1466 Posts |
Posted - 2005-07-28 : 04:51:00
|
| select isnull(myvalue, 0)orselect coalesce(myvalue, 0)Duane. |
 |
|
|
olay80
Yak Posting Veteran
62 Posts |
Posted - 2005-07-28 : 07:21:17
|
| thanx man |
|
|
|
|
|
|
changing a value