How to track down doubloons in valentina ?

[olivier]

valentina 1.90 RB 5.5.3 os X 3.3

Hi Ruslan and list,

How to track down doubloons in Valentina?
For example in an address book, we sometimes have several records for 
the same person/society :

e.g.
- record 100 : field name : "PARADIGMA SOFTWARE"
- record 9134 : field name :"SOCIETY PARADIGMA"
- record 9877 : field name : "RUSLAN PARADIGMA SOFT."

The following request SQL does not work in Valentina.
How can it be done? (without passing by an enormous loop in RB)

SELECT * FROM address t1, address t2 WHERE t1.name LIKE t2.name AND 
t1.recid<>t2.recid

(in Oracle : SELECT * FROM address T1 JOIN address T2 ON (T1.name LIKE 
'%'+T2.name+'%' AND T1.rowId<>T2.rowId))

thank you

olivier