特定的模糊查询（在线等）

[llh6795]

select * from laof where f_cp between 6001-a and 6008-b;

用户要求输入6001和6008即可查出6001至6008-b的所有数据，应该怎么实现这个特定的模糊查询呢？请大家多指教，先谢谢了：）））

[llh6795]

偶已经解决了，接铁了：）））

[mugua604]

用or不可以吗？！

[llh6795]

TO mugua604 :
用or不可以：）））

[playwarcraft]

--try?
where left(f_cp,4) between '6001' and '6008'

[marco08]

a, b是什麽啊

[llh6795]

select * from laof where f_cp between '6001-a' and '6008-b';

[marco08]

select * from laof
where left(f_cp, 4) in
('6001', '6002', '6003', '6004', '6005', '6006', '6007', '6008')

[llh6795]

谢谢楼上的个位朋友，贴出原码，条件输在cxgrid控件内
SELECT * FROM LAOF WHERE '+COND_Qry1.FieldValues['F_FIELD']
+' between '''+COND_Qry1.FieldValues['F_LOWER']
+ ''' AND '''+COND_Qry1.FieldValues['F_UPPER']+''' ;

[marco08]

把表結構和數據貼出來看看

[llh6795]

我的字段都是字符型的

SELECT * FROM LAOF WHERE'+COND_Qry1.FieldValues['F_FIELD']
+' LIKE '''+COND_Qry1.FieldValues['F_LOWER']
+ '%'+''' AND '+COND_Qry1.FieldValues['F_FIELD']
用上面这个语句只能 F_LOWER 和 F_UPPER 输入如6001至6001才可以，而输入6001至6003却不行

[llh6795]

'+COND_Qry1.FieldValues['F_FIELD']
+' LIKE '''+COND_Qry1.FieldValues['F_LOWER']
+ '%'+''' AND '+COND_Qry1.FieldValues['F_FIELD']
+' LIKE '''+COND_Qry1.FieldValues['F_UPPER']+'%'+''' ';

[llh6795]

字段是字符型的
SELECT * FROM LAOF WHERE '+COND_Qry1.FieldValues['F_FIELD']
+' LIKE '''+COND_Qry1.FieldValues['F_LOWER']
+ '%'+''' AND '+COND_Qry1.FieldValues['F_FIELD']
+' LIKE '''+COND_Qry1.FieldValues['F_UPPER']+'%'+''' ';

这个语句只能 F_LOWER 和 F_UPPER 输入如6001至6001才可以，而输入6001至6003却不行

[marco08]

like 查詢不能這樣用的

[llh6795]

TO marco08: 3Q~~~3Q
俺用的是DELPHI+SQL
但是新手，基本功差，还请多指教：）））