Thank you for your suggestion.
I realise I probably did not explain fully enough my goal.
Let's say I have 10 columns in my table (excluding the PK).
I only want to store a data row into the table if the combination of all 10 values is a unique combination set.
Example with a 3 column table:
INSERT Row 1: A,A,A <== OK! Value set unique
INSERT Row 2: A,D,A <== OK! Value set unique
INSERT Row 3: D,T,G <== OK! Value set unique
INSERT Row 4: D,A,A <== OK! Value set unique
INSERT Row 5: A,D,A <== COLLISION with Row 2! Set not unique; skip IN
+SERT
|