Larry,

The data in fl2 will only ever have either:
1) Blank or
2) Non blank, but always the same non blank chracters

I think Max should work here, as all I really need is the Non blank character record only, or if there is ONE blank record, I need that one.

Regards,

Gerard







>>Larry, thanks for your reply.
>>
>>I also need records , where there may be only one blank fld2 entry, so I dont think below will work.
>>I got another reply on this thread which suggested using Max(fld2) whicj I think may work.. I'll give it a try.
>>
>>Regards,
>>
>>Gerard
>>
>If the values in fld2 are always going to be the same for each value in fld1 (i.e. AA corresponds to Widgets) then MAX will work. If there are going to be different values for the same value in fld1 (i.e. AA could have Diamonds or Widgets) then MAX will not work.
>
>MAX will return the largets value in terms of ASCII value. This means that words that start with Z are larger than words that start with Y and so on. Also, capital letters are larger than lower case letters.