字段 name
ab
ac
dwc
852dq
311pp
查询以后
abb
acc
dwcc
852dqq
311ppp
------解决方案--------------------
- SQL code
--演示环境CREATE TABLE TEST(NAME VARCHAR(20))INSERT INTO TESTSELECT 'ab' UNION ALLSELECT 'ac' UNION ALLSELECT 'dwc' UNION ALLSELECT '852dq' UNION ALLSELECT '311pp'------查询SELECT * FROM TESTSELECT (NAME+RIGHT(NAME,1)) AS RESULTFROM TEST---/*RESULT----------------------abbaccdwcc852dqq311ppp(5 行受影响)*/DROP TABLE TEST