Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Replacing NULL with 0
Message
De
29/09/2004 00:51:01
Kevin Goff
Pennsylvanie, États-Unis
 
 
À
29/09/2004 00:37:41
Martin Metharam
Manila, Philippines
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Syntaxe SQL
Titre:
Re: Replacing NULL with 0
Divers
Thread ID:
00947052
Message ID:
00947053
Vues:
16
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform