Posted by Chris.Cheney on 05/30/07 07:40

I should have written

COALESCE(Col1, 0) + COALESCE(Col2, 0) + COALESCE(Col3, 0) + 0*COALESCE
(Col1, Col2, Col3)

• Next in forum: Re: needed: 1 + null = 1
• Prev in forum: Re: What do you think about the checksum function ?
• Thread view: Re: needed: 1 + null = 1 (Correction)

[Reply to this message]