以某个变量结束的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||'%') );