怎么让内容后面多增加一个同样的字母

--演示环境
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