怎么把'1,2,3'变为'1','2','3'

Question

Select Replace('''1,2,3''',',',',''')原理:用“,'”组合去替换“,”即可注意:SQL中“'”需要用“'''”（三个“'”）来表示...

Answer 1

select ''''+replace('1,2,3',',',''',''')+''''

Answer 2

declare @s varchar(2000),@result varchar(2000)
set @s='1,2,3'
select @result= ''''+replace(@s,',',''',''')+''''
select @result
/*
'1','2','3'
*/

Answer 3

declare @char varchar(100)
set @char='''1,2,3,4,5,6'''
select @char --转换前@char的值
set @char=replace(@char,',',''',''')
select @char --转换后@char的值
/*结果                                                                                                     
-------------------------------
'1,2,3,4,5,6'（所影响的行数为 1 行）                                                                                                     
--------------------------------
'1','2','3','4','5','6'（所影响的行数为 1 行）