>>
>>Probably I misunderstand you but why you could not run command:
>>SELECT * from mytable where Score=nScore
>
>scenario:
>
>rec#1 98.2
>rec#2000 98.2
>rec#300 100
>rec#4 100 etc.
>
>I'm looking for the tie here and not a particular score? And I also need to list everyone with similar scores...
>
>TIA
OK. You have to :
1. Create temp cursor with tied scores
Select score from mytable into cursor tmp having count(*)>1 group by score
2. Join two tables by score field
Select mytable.* from mytable,tmp where mytable.score=tmp.score
Edward Pikman
Independent Consultant