--演示环境
CREATE TABLE TEST(NAME VARCHAR(20))
INSERT INTO TEST
SELECT 'ab' UNION ALL
SELECT 'ac' UNION ALL
SELECT 'dwc' UNION ALL
SELECT '852dq' UNION ALL
SELECT '311pp'
------查询
SELECT * FROM TEST

SELECT (NAME+RIGHT(NAME,1)) AS RESULT
FROM TEST
---
/*
RESULT
----------------------
abb
acc
dwcc
852dqq
311ppp

(5 行受影响)*/
DROP TABLE TEST