• 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