select INSTR(RTRIM(DWGMC),'(',-1) as ID,dwgmc,substr(dwgmc,INSTR(RTRIM(DWGMC),'(',-1)+1,INSTR(RTRIM(DWGMC),')',-1)-INSTR(RTRIM(DWGMC),'(',-1)-1)
from entity_index where dwgmc like '%(0600%)%'
请问这个语句对吗??查询的时候报错说没有INSRT函数!要是不对该怎么写,急用,万分感谢!!!!
...全文
1104打赏收藏
请高手!!有关sqlserver语句问题,
select INSTR(RTRIM(DWGMC),'(',-1) as ID,dwgmc,substr(dwgmc,INSTR(RTRIM(DWGMC),'(',-1)+1,INSTR(RTRIM(DWGMC),')',-1)-INSTR(RTRIM(DWGMC),'(',-1)-1) from entity_index where dwgmc like '%(0600%)%' 请问这个语句对吗??查询的时候报错说没有INSRT函数!要是不对该怎么写,急用,万分感谢!!!!