Hi All,
I need to create a cursor from a 1-to-Many join that only shows the $ amounts on the 1 side one time. I can do a scan...endscan on the cursor and zero out the second and following amounts, but... Isn't there an easier way?

Consider:

Claims Table
Mem_Num  Clm_Id  Clm_Amt
1        10      $50
2        20      $25
3        30      $15

Eligibility Table
Mem_Num  Pln_Id
1        AETNA
1        BCBS
2        CIGNA

Results from Left Outer Join on Mem_Num
Mem_Num  Clm_Id  Clm_Amt  Pln_Id
1        10      $50      AETNA
1        10      $50      BCBS
2        20      $25      CIGNA
3        30      $15      N/A

Required Results
Mem_Num  Clm_Id  Clm_Amt  Pln_Id
1        10      $50      AETNA
1        10      <B><I>$0</B></I>       BCBS
2        20      $25      CIGNA
3        30      $15      N/A

Am I dreaming? Any ideas welcome.