>

>select systemdealnumber,systemaccounttype, ;
> systemdealnumber+systemaccounttype as combined ;
> from myTable ;
> having cnt(*) > 1 ;
> group by combined
>

Cetin,

Thank you for responding. I tried this statement and the statement from the other post and I am not getting a result set from this. FYI, SystemDealNumber is an Integer type so I'm really using STR(SystemDealNumber,10,0)+SystemAccountType for the key string.

Any ideas as to why nothing would be coming back?

Jon