Bob:

I'm just getting up to speed on SQL 7, so I'm still learning a lot. I'm not sure if there is an easier way, but this works. Create a temp table to hold the return value to the SP.

*- Cases is the name of the table I'm getting the key from

create table #temptable
(table_qualifier char(20),
table_owner char(20),
table_name char(20),
column_name char(20),
key_seq char(20),
pk_name char(20))

insert into #temptable (table_qualifier, table_owner, table_name,
column_name, key_seq,pk_name) execute sp_pkeys 'cases'

select column_name from #temptable