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 |
|
asad.lte
Starting Member
32 Posts |
 Posted - 2010-06-18 : 10:19:55
|
| hai experts,i have a oracle query need to write in sqlserver, m stuckup to do tht.plz support me as we dont have nvl function in sqlserver ,shud go wid case but facing isues.Select distinct dealerid, upper(NVL(nondealer,’NULL_VALUE’)) from dbo.d_profile ORDER by 1,2 |
|
|
jimf
Master Smack Fu Yak Hacker
2875 Posts |
Posted - 2010-06-18 : 10:23:58
|
| try upper(isnull(nondealer,'NULL_VALUE))JimEveryday I learn something that somebody else already knew |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-06-18 : 10:29:16
|
| I'm sure obvious to O/P ... but in case not:upper(isnull(nondealer,'NULL_VALUE')) |
|
|
|
|
|
|
oracle to sql server convert