Suggestion for enforcing unique constraint in a table where soft delete is implemented
Why not somthing simple like this:



User enters position 'President' and it does not exist in the table.

Insert Into table



User deletes position 'President'. 

Update table set isDeleted = 1



User changes mind and again enters a position 'President'. 

Update table set isDeleted = 0