RE: Omit record from SQL AVG based on field value

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.