locating field duplicates

[Tim Davis]

>    Is there a way in VApp to search for field value duplicates? I have 
> a table in which a field is unique, but when indexing it fails due to 
> the field being unique. I'd rather modify the data than switch off the 
> unique property (even though it didn't stop this occurrence entirely).

More info...
The records that became duplicates were modified (Updated) using SQL on 
the Server.
Isn't the unique field property supposed to prevent creating duplicate 
field values?

Thanks,
Tim Davis