SELECT LEFT(@string,10)
returns
Hello how
SELECT LEN(LEFT(@string,10)) - LEN(REPLACE(LEFT(@string,10), 'o', ''))
returns
2
We are now replicating the word
Hello how 2 times by using
SELECT REPLICATE(',' + LEFT(@string,10),LEN(LEFT(@string,10)) - LEN(REPLACE(LEFT(@string,10), 'o', '')))
which returns
,Hello how ,Hello how
The stuff function removes the leading
,
SELECT STUFF(REPLICATE(',' + LEFT(@string,10),LEN(LEFT(@string,10)) - LEN(REPLACE(LEFT(@string,10), 'o', ''))),1,1,'')
resulting
Hello how ,Hello how