Home Forums SQL Server 2005 Administering Case statement and unique index RE: Case statement and unique index

  • May 11, 2005 at 4:43 am

    #558007

    Or you could add a computed column and use that in the index.

    --
    Chris Hedgate http://www.hedgate.net/
    Contributor to the Best of SQL Server Central volumes
    Articles: http://www.sqlservercentral.com/columnists/chedgate/