如题,我运行一个查询语句:
SELECT wcks FROM JCXX WHERE ID='1408070119'
然后数据库里返回一个查询结果:
ET+KQ+TZJ+WZ
但是这里面有我+TZJ+WZ不需要显示,我只需要显示
ET+KQ就可以了,想问问有没有办法解决?
------解决思路----------------------
SELECT STUFF(REPLACE(REPLACE('+'+wcks, '+ET', ''), '+KQ', ''), 1,1,'') wcksSELECT wcks FROM JCXX WHERE ID='1408070119'
SELECT STUFF(REPLACE(REPLACE('+'+wcks, '+ET', ''), '+KQ', ''), 1,1,'') wcks