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")
[解决办法]
就你贴出的语句来看，我不相信没有 - 时能查到数据而不报错
