懂了，用条件筛选数字排序！

SELECT * FROM b1 WHERE ISDIGIT(m1) ORDER BY m1 DESC

谢谢！

SELECT TOP 10 * FROM b1 ORDER BY m1 DESC &&前10名

谢谢！

CLEAR
SET COLLATE TO "MACHINE"
create cursor b1 (m1 c(1))
insert into b1 values ("")
insert into b1 values ("1")
insert into b1 values ("N")
insert into b1 values ("8")
insert into b1 values ("M")
insert into b1 values ("5")
COPY TO ARRAY abb
ASORT(abb, 1, ALEN(abb), 1)
LIST MEMORY LIKE abb
下标即排序的名次

如果只是求最大最小值，可以用帮助文件里的范例：
gnMaximum = 0
gnMinimum = 1000
SCAN
   gnMinimum = MIN(gnMinimum, b1)
   gnMaximum = MAX(gnMaximum, b1)
ENDSCAN

哈哈。

select max(M1) from B1