动态sql中like条件加变量
以某个变量结束的like条件怎么写？
以下这句不对
select * from test where name like :ls_name+'%';
[解决办法]
ls_name = ls_name + '%'
select * from test where name like :ls_name ;
[解决办法]
ls_name ='%' + ls_name + '%'
select * from test where name like :ls_name ;
[解决办法]
注意: 嵌入式SQL 不能这么写, 用来做动态DW 可以.
[解决办法]
select * from test where name like '" + ls_name + "%'"
[解决办法]
ls_name ='%' + ls_name + '%'
select * from test where name like :ls_name ;
[解决办法]
select * from test where name like :ls_name || '%';
[解决办法]
ls_name ='%' + ls_name + '%'
select * into :变量名称 from test where name like :ls_name ;
[解决办法]
ls_name=dw_1.getitemstring(ll_i,"goodsname")
ls_prodarea=dw_1.getitemstring(ll_i,"prodarea")
select count(*) into :ll_flag2 from bms_st_qty_lst where goodsid in(
select goodsid from pub_goods where
(goodsname like :ls_name) and (prodarea like '%'||:ls_prodarea||'%') );
