[AccessD] SQL Server - Distinct ignores null?

Have you tried giving the null a value?

Eg. In the QBF,

MyFld:nz(Myfield,"")

Or

MyFld:nz(Myfield,0)

Max


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: 18 September 2009 18:41
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