17,377
社区成员
发帖
与我相关
我的任务
分享
select xlmc,xd from Tz_Xdxxb WHERE nvl(substr(HC,INSTR(HC,'#')+1,10),'0')='1'
--估计你的hc字段是定长的,所以导致这样的结果
select count(nvl(substr(HC,INSTR(HC,'#')+1,10),0)) from Tz_Xdxxb WHERE xlmc='05' and xd=201
看有多少记录
--试试这样
select xlmc,xd from Tz_Xdxxb
WHERE instr(trim(substr(HC,INSTR(HC,'#')+1,10)),'1')>0
--or
select xlmc,xd from Tz_Xdxxb
WHERE to_number(nvl(substr(trim(HC),INSTR(HC,'#')+1,10),0))=1
--你用这个试试
--nvl()要求字段类型一致 你这种还是用decode比较好
select xlmc,xd
from Tz_Xdxxb
WHERE to_number(decode(substr(HC,INSTR(HC,'#')+1,10),null,0))=1
select xlmc,xd from Tz_Xdxxb WHERE xlmc='05' and xd=201 and to_number(nvl(substr(HC,INSTR(HC,'#')+1,10),0))=1