Sql Help

[ranjith23]

I have a table(PERSONS) which contains employee "NAME". its in this format (example: Varun,Guduru K).

 

I want that it to be converted into this format. (Guduru K. Varun)

 

I'm on SQL server. Thanks

[SwamyRaRa]

select 'Varun,Guduru K'

select substring('Varun,Guduru K',charindex(',','Varun,Guduru K')+1,charindex(' ','Varun,Guduru K'))+'. '+substring('Varun,Guduru K',1,charindex(',','Varun,Guduru K')-1)

[ranjith23]

select 'Varun,Guduru K'

select substring('Varun,Guduru K',charindex(',','Varun,Guduru K')+1,charindex(' ','Varun,Guduru K'))+'. '+substring('Varun,Guduru K',1,charindex(',','Varun,Guduru K')-1)

thanks bhaya