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

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?