In my table not all colums have values, but duplicates exist.

My standard setting is:                 SET EQNULL OFF, NULL: -0-

I want:                                                 DELETE DUPLICATES
FROM TABLE

result is:                                              0 duplicates have
been deleted

but when:                                          SET EQNULL ON

the command is successful:       n duplicates have been deleted !

Question:           Should this command not also work on a table with
setting SET EQNULL OFF ?

Thank“s

Fritz

Reply via email to