CREATE CURSOR tmp (读者证号 C(7),借阅日期 D,中图分类号 C(12))
INSERT INTO tmp VALUES ('2003001',DATE(2006,12,07),'tp3/123')
INSERT INTO tmp VALUES ('2003001',DATE(2006,12,07),'h1233.44/11')
INSERT INTO tmp VALUES ('2003001',DATE(2006,12,07),'tp311.1/12')
SELECT 读者证号,借阅日期,SUBSTR(中图分类号,1,AT('/',中图分类号)-1)+SPACE(12) 中图分类号 FROM tmp
INSERT INTO tmp VALUES ('2003001',DATE(2006,12,07),'tp3/123')
INSERT INTO tmp VALUES ('2003001',DATE(2006,12,07),'h1233.44/11')
INSERT INTO tmp VALUES ('2003001',DATE(2006,12,07),'tp311.1/12')
SELECT 读者证号,借阅日期,SUBSTR(中图分类号,1,AT('/',中图分类号)-1)+SPACE(12) 中图分类号 FROM tmp
感言:学以致用。 博客:http://www./blog/user14/65009/index.shtml email:Tiger5392@