It's not meaningless to me. It tells me which file the record came from, which was the whole point of adding it.

Thanks,

Michelle


>Michelle, if you eliminate duplicates by "purno" then the value of "chfile" will be meaningless since, well, only one value (either "C" or "H") will be returned.