Comma delimited list to string sql

Question

i need to convert the following values from a variable:

1234,1234,12345,12346,1344,4564

to this:

'1234','1234','12345','12346','1344','4564'

using an SQL function.

I have tried:

DECLARE @VAL AS VARCHAR(MAX)
SELECT @VAL = '1234,1234,12345,12346,1344,4564'

DECLARE @listStr VARCHAR(MAX)
SELECT @listStr = COALESCE(@listStr+',' ,'') + @VAL
SELECT @listStr AS 'List'
GO

But i get:

1234,1234,12345,12346,1344,4564

Answer 1

Try this:

SELECT '''' + REPLACE('1234,1234,12345,12346,1344,4564', ',', ''',''') + '''';

Check this SQL FIDDLE DEMO

OUTPUT

|                                    COLUMN_0 |
|---------------------------------------------|
| '1234','1234','12345','12346','1344','4564' |

EDIT

Use User defined function:

CREATE FUNCTION dbo.ufnReplace(@Val VARCHAR(MAX))
RETURNS VARCHAR(MAX) 
AS 
BEGIN
    SELECT @Val = '''' + REPLACE(@Val, ',', ''',''') + '''';
    RETURN @Val;
END;

SELECT dbo.ufnReplace('1234,1234,12345,12346,1344,4564');

Answer 2

DECLARE @VAL AS VARCHAR(MAX)
SELECT @VAL = '1234,1234,12345,12346,1344,4564'
SELECT '''' + REPLACE(@VAL,',',''',''') + ''''

Answer 3

Using REPLACE() and CONCAT():

select concat("\'", replace('1234,1234,12345,12346,1344,4564', ',', "\',\'"), "\'")