SQL Server 字符根据特殊符号转换

将 AAA,AAC 字符串 根据逗号分割为两条数据，或者拼接单引号

SELECT SUBSTRING
        ( str, b.number, charindex( ',', str + ',', b.number ) - b.number ) AS abc 
    FROM
        ( SELECT 'AAA,AAC' AS str ) a
        INNER JOIN master.dbo.spt_values b ON b.number BETWEEN 1 
        AND len( str ) 
        AND SUBSTRING ( ',' + str, b.number, 1 ) = ',' 
    WHERE
        b.type= 'P' ​ 
    
    

 

SELECT REPLACE( concat ( '''', s.str, '''' ), ',', ''',''' )  FROM ( SELECT 'AAA,AAC' AS str ) s