以下是引用吹水佬在2021-6-20 16:44:45的发言:
是有点问题,这样呢
*可填报
SELECT 必修科数,必修科目 FROM 样表 WHERE (LENC(CHRTRANC(必修科目,", ",""))-LENC(CHRTRANC(必修科目,", 物生地","")))>=VAL(必修科数)
*不可填报
SELECT 必修科数,必修科目 FROM 样表 WHERE !(LENC(CHRTRANC(必修科目,", ",""))-LENC(CHRTRANC(必修科目,", 物生地","")))>=VAL(必修科数)
是有点问题,这样呢
*可填报
SELECT 必修科数,必修科目 FROM 样表 WHERE (LENC(CHRTRANC(必修科目,", ",""))-LENC(CHRTRANC(必修科目,", 物生地","")))>=VAL(必修科数)
*不可填报
SELECT 必修科数,必修科目 FROM 样表 WHERE !(LENC(CHRTRANC(必修科目,", ",""))-LENC(CHRTRANC(必修科目,", 物生地","")))>=VAL(必修科数)
谢谢,老师.