Inserting Duplicate Records

[eluser]zorka[/eluser]
<quote>
Wrong! you’re performing another SQL just to see if a record exists</quote>

Don't you mean RIGHT? I asked if 'this' (attempting insert WITHOUT checking via select) is faster than doing the select and THEN an insert... I think omitting the word "and" in the last sentence may have nixed it...

In any case - your solution is exactly what I was looking for, I can now attempt insert without having to traverse the database twice due to a pre-insert-select-check...

ThanX