Vfp9与ORACAL数据库连通后，下面语句如何写才对：
Frsbh类型：C
ss1=sqlexec(connectid,"select * from frdb where LEFT(frsbh,4)> 5301","frdb")--无反应
ss1=sqlexec(connectid,"select * from dj_nsrxx where LEFT(nsrsbh,4)> "5301"","dj_nsrxx")--提示函数名缺少
多谢各位老师指教
------解决方案--------------------------------------------------------
oracle 中改成如下。
ss1=sqlexec(connectid,"select * from frdb where substr(frsbh,1,4)> 5301","frdb")
------解决方案--------------------------------------------------------
ORACLE没有LEFT 函数
ss1=sqlexec(connectid,"select * from frdb where substr(frsbh,1,4)> '5301'","frdb")
------解决方案--------------------------------------------------------
or
ss1=sqlexec(connectid,"select * from frdb where CAST(substr(frsbh,1,4) as NUMBER)> 5301","frdb")