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 |
mr_dayal
Starting Member
37 Posts |
Posted - 2008-07-15 : 07:54:08
|
Is there Any alternate of NVL() function of oracle ,so that I want to replace the null values with some value.Mr Dayal |
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2008-07-15 : 08:09:11
|
This is SQL Server specific site. Please post oracle related questions on respective site forums.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
|
|
elancaster
A very urgent SQL Yakette
1208 Posts |
Posted - 2008-07-15 : 08:09:21
|
coalesce() you can find the details in books onlineEm |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-07-15 : 08:12:03
|
Yes. Use ISNULL() function or COALESCE() function. E 12°55'05.25"N 56°04'39.16" |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-07-15 : 08:27:49
|
Also refer this to know differencehttp://blogs.msdn.com/sqltips/archive/2008/06/26/differences-between-isnull-and-coalesce.aspx |
|
|
|
|
|