Discussion: null value
Afficher un message
Vieux 03/04/2008, 11h15   #1
Massimo
Aucun Avatar
 
Messages: n/a
Hébergeur:
Par défaut null value

Hi,
i have a problem with the following query:

select (c1+c2+c3) as tot from tab

c2 or c3 can have value null.
When c1 or c2 are null, tot=null but i need that tot=c1

Thanks

bye,
max


  Réponse avec citation
 
Page generated in 0,04282 seconds with 9 queries