How can split a string in sql using comma delimiter

Question

how can split a strin in sql using comaa delimiter 


thanks in advance