Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Replacing NULL with 0
Message
From
29/09/2004 00:51:01
Kevin Goff
Pennsylvania, United States
 
 
To
29/09/2004 00:37:41
Martin Metharam
Manila, Philippines
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Title:
Re: Replacing NULL with 0
Miscellaneous
Thread ID:
00947052
Message ID:
00947053
Views:
15
This message has been marked as the solution to the initial question of the thread.
Martin,

I'm not sure if this will help, but you might want to check out the ISNULL function...check the syntax in the online help, but basically...
SELECT ISNULL(Myfield,0) as credit
So any nulls would be brought back as zero...does that help?

Kevin
"Run, you clever boy....and remember"
https://www.youtube.com/watch?v=8U4Y2Uv8ArM

"My survival...my living proof"
https://plus.google.com/photos/117162300364810952313/albums/5876836271056272097/5876836294121419858?banner=pwa&pid=5876836294121419858&oid=117162300364810952313
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform