22,210
社区成员
发帖
与我相关
我的任务
分享
--测试数据
IF OBJECT_ID('tempdb..#tab') IS NOT NULL
DROP TABLE #tab
CREATE TABLE #tab
(
LL VARCHAR(50)
)
INSERT INTO #tab
SELECT '张三,李四,王五'
--测试数据结束
SELECT ''''+REPLACE(LL,',',''',''')+'''' AS LL FROM #tab
LL
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
'张三','李四','王五'
[/quote]
谢谢,非常感谢
--测试数据
IF OBJECT_ID('tempdb..#tab') IS NOT NULL
DROP TABLE #tab
CREATE TABLE #tab
(
LL VARCHAR(50)
)
INSERT INTO #tab
SELECT '张三,李四,王五'
--测试数据结束
SELECT ''''+REPLACE(LL,',',''',''')+'''' AS LL FROM #tab
LL
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
'张三','李四','王五'
SELECT '张三'+',李四'+',王五'
SELECT 字段1+字段2+字段3 FROM 表