I am looking for a way to pull out a distinct list. I have a table, PROTOCOL, in the table one of the fields is PI. THere can be many protocols that have the same PI. I want a list of all of the PI's that have a protocol, but I only want them to show up once each.

What do you think

S

SB

Do you say you want a list of all the different values in a field? If that field is indexed you can do it programmatically with

list=Collect.IXVals(filename, fieldname)

that returns the list of index values for the specified indexed field in the specified file, or

Extract_SI_Keys(tablename, columnname, value, keylist)

that searches a Btree index for a specified value and returns a list of keys based on the search value.

(Or you might perhaps use a relational index.)

- Oystein -

Thanks, that first one sounds like what I am looking for.

S

SB,

It's fine as long as you haven't got *too* many values.

- Oystein -

View this thread on the forum...