>>
>>There is also the SET ENGINEBEHAVIOR control this
>
>I don't recomend using it w/o good reason.

After reading the documentation I decided against it, instead I’ll modify the design to not allow duplicate records on the table.

It is difficult for me to use the padl() function because this is a query maker program so the field selection will get a lot more complex.