27,579
社区成员
发帖
与我相关
我的任务
分享
/* 测试数据
WITH table1(id,name,address) AS (
SELECT 1,'a','k road 333, east area' UNION ALL
SELECT 2,'b','"j garden" 555
west area'
)
*/
SELECT id,
name,
'"'+REPLACE(address,'"','""')+'"' address
FROM table1
id,name,address
1,a,"k road 333, east area"
2,b,"""j garden"" 555
west area"