RE: Omit record from SQL AVG based on field value

[<Rick.Chevalier@xxxxxxxxxxxxxxx>]

What can I say, it's true.  :)


> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx
> [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Elvis Budimlic
> Sent: Friday, February 02, 2007 3:05 PM
> To: 'Midrange Systems Technical Discussion'
> Subject: RE: Omit record from SQL AVG based on field value
>
> In Rick's case it was a PICNIC - Problem In Chair Not In
> Computer (sorry Rick :)
>
> You're right as far as NULL comparison is concerned though.
> Even comparing a field that's NULL against itself or another
> field that's NULL will evaluate to NULL.  Why?  Because if
> something's void of value, how can you compare it with anything?
>
> Elvis
>
> Celebrating 10-Years of SQL Performance Excellence

Privileged and Confidential.  This e-mail, and any attachments there to, is 
intended only for use by the addressee(s) named herein and may contain 
privileged or confidential information.  If you have received this e-mail in 
error, please notify me immediately by a return e-mail and delete this e-mail.  
You are hereby notified that any dissemination, distribution or copying of this 
e-mail and/or any attachments thereto, is strictly prohibited.