[AccessD] SQL Server - Distinct ignores null?

jwcolby jwcolby at colbyconsulting.com
Fri Sep 18 12:41:04 CDT 2009


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



More information about the AccessD mailing list