SELECT * FROM TABLENAME WHERE FIELDNAME LIKE 'F%' ORDER BY FIELDNAME ASC union SELECT * FROM TABLENAME WHERE SUBSTRING(FIELDNAME,1,1) <> 'F' ORDER BY FIELDNAME ASC
用两个RECORDSET集合
1、SELECT * FROM TABLENAME WHERE FIELDNAME LIKE 'F%' ORDER BY FIELDNAME ASC
2、SELECT * FROM TABLENAME WHERE SUBSTRING(FIELDNAME,1,1) <> 'F' ORDER BY FIELDNAME ASC
SELECT * FROM TABLENAME WHERE FIELDNAME LIKE 'F%' ORDER BY FIELDNAME ASC union SELECT * FROM TABLENAME WHERE SUBSTRING(FIELDNAME,1,1) <> 'F' ORDER BY FIELDNAME ASC