[AccessD] SPAM-LOW: [dba-SQLServer] Null and DISTINCT

jwcolby jwcolby at colbyconsulting.com
Fri Sep 18 13:03:00 CDT 2009


Never mind...   LOL.

ISNULL(MyFld,0).

John W. Colby
www.ColbyConsulting.com


jwcolby wrote:
> 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?



More information about the AccessD mailing list