读书人

VFP SQL200 LIKE 查询时字段当中有“-

发布时间: 2013-09-05 16:02:07 作者: rapoo

VFP SQL200 LIKE 查询时字段中间有“-”时查询不到?
VFP SQL200 LIKE 查询时字段中间有“-”时查询不到?
[解决办法]
应该是可以的,请分别试试如下:
=SQLEXEC(FCON1,"SELECT * FROM RS33 WHERE XM LIKE ?X1","TEMP")
or
=SQLEXEC(FCON1,"SELECT * FROM RS33 WHERE XM LIKE 'FW-%'","TEMP")
or
=SQLEXEC(FCON1,"SELECT * FROM RS33 WHERE XM LIKE '%FW-%'","TEMP")

[解决办法]
就你贴出的语句来看,我不相信没有 - 时能查到数据而不报错

读书人网 >VFP

热点推荐