[AccessD] SQL Server - Distinct ignores null?

You know you can't compare a null to anything, John.  Distinct is
working.

Charlotte 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: Friday, September 18, 2009 10:41 AM
To: Access Developers discussion and problem solving; "SQL
Server"@databaseadvisors.com
Subject: [AccessD] SQL Server - Distinct ignores null?

I have a result set where I have a ton of records that are absolutely
identical.  I am trying to do a DISTINCT but there is one field that is
pulling a NULL.  Is it true that the NULL will prevent the DISTINCT from
working in this case?

Any way around this?
--
John W. Colby
www.ColbyConsulting.com
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com