How do I change name format in TSQL Query Result?
DECLARE @Name varchar(100) = 'Doe, Jane'


SELECT SUBSTRING(@Name,CHARINDEX(',',@Name)+1,LEN(@Name) - CHARINDEX(',',@Name) )+ ' ' + SUBSTRING(@Name,1,CHARINDEX(',',@Name)-1)