Re: needed: 1 + null = 1 (Correction)
- From: "Chris.Cheney" <Chris.CheneyXXNOSPAMXX@xxxxxxxxx>
- Date: Wed, 30 May 2007 07:40:07 GMT
I should have written
COALESCE(Col1, 0) + COALESCE(Col2, 0) + COALESCE(Col3, 0) + 0*COALESCE
(Col1, Col2, Col3)
.
- Follow-Ups:
- Re: needed: 1 + null = 1 (Correction)
- From: info
- Re: needed: 1 + null = 1 (Correction)
- References:
- needed: 1 + null = 1
- From: info
- Re: needed: 1 + null = 1
- From: Chris.Cheney
- Re: needed: 1 + null = 1
- From: info
- Re: needed: 1 + null = 1
- From: M A Srinivas
- Re: needed: 1 + null = 1
- From: Robert Klemme
- Re: needed: 1 + null = 1
- From: Chris.Cheney
- needed: 1 + null = 1
- Prev by Date: Re: What do you think about the checksum function ?
- Next by Date: Re: needed: 1 + null = 1
- Previous by thread: Re: needed: 1 + null = 1
- Next by thread: Re: needed: 1 + null = 1 (Correction)
- Index(es):
