select * from T_table where left(isnull(F_id,''),charindex('-',isnull(F_id,''))-1) like '"trim(txt_id.text)"%'
select * from T_table where substring(isnull(txt_id,0),0,charindex('-',txt_id)) like '01022'select * from T_table where substring(isnull(txt_id,0),0,charindex('-',txt_id)) like '"trim(txt_id.text)"%'
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货