SELECT TOP 1 [fieldName] from [tableName] into cursor [cursorName] order by [fieldName] desc
That should get you the single largest value for that field in the table. If there is a tie, it will give you all records with that value, not just the top 1.
Is that what you wanted?
Paul A. Busbey
Victoria Insurance
