>Hi,
>I have a table that has two fields in it, 1. ssnumber 2. insurance company name (name1 or name2).
>What I'm trying to do is search the table for insurance company name1 and name2 with the same
>ssnumber. both fields are indexed. Then replease a field called both with a "B".
>
>Any ideas?
>
>Thanks
Hi John,
It's a little bit unclear what are you trying to achieve. If you'd like to eliminate duplicates, you can run simple query:
select *, count(*) as cnt_dups from yourtable group by ssnumber having cnt_dups>1
Hope this helps.
If it's not broken, fix it until it is.
My Blog