I already asked this question but I wanto ask it again but in a different way. I have duplicate values(not really but..). The duplicate would be when a pataccount(which is not a key of any sort, its a varchar(10)) and one of the Pataccounts have a leading zero and the other one doesnt. They both have unique AcctIDs(Primary Key). The question is how do I get a row back with both the Pat Account with the leading zero and the PatAccount without the leading 0 in the same row. It also has to have the status of both. I want it to look as follows...
AcctID PatAccount Status PatAccount Status
123 56789 CW 056789 UP
456 89768 PO 089768 NC