A code showing a unique filtered index would be like this:
CREATE UNIQUE NONCLUSTERED INDEX UX_TableName_Field ON dbo.TableName(Field)
WHERE Field IS NOT NULL;
Best regards,
Best regards,
Andre Guerreiro Neto
Database Analyst
http://www.softplan.com.br
MCITPx1/MCTSx2/MCSE/MCSA