WITH names( fullname) AS(
	SELECT 'shah, anki S.' UNION ALL 
	SELECT 'dogula nanacy' UNION ALL
	SELECT 'baskin brian B' UNION ALL 
	SELECT 'waive, FRANCISCO p.' UNION ALL 
	SELECT 'le, pinti' UNION ALL 
	SELECT 'Leo, tomy'),
names2 AS(
	SELECT REPLACE(REPLACE(REPLACE(fullname, '.',''),',', ''), ' ', '.') AS formatname
	FROM names
)
SELECT REVERSE( PARSENAME(REVERSE(formatname), 1)),
	REVERSE( PARSENAME(REVERSE(formatname), 2)),
	REVERSE( PARSENAME(REVERSE(formatname), 3))
FROM names2

WITH names( fullname) AS(
	SELECT 'shah, anki S.' UNION ALL 
	SELECT 'dogula nanacy' UNION ALL
	SELECT 'baskin brian B' UNION ALL 
	SELECT 'waive, FRANCISCO p.' UNION ALL 
	SELECT 'le, pinti' UNION ALL 
	SELECT 'Leo, tomy'
)
SELECT REVERSE( PARSENAME(REVERSE(REPLACE(REPLACE(REPLACE(fullname, '.',''),',', ''), ' ', '.')), 1)),
	REVERSE( PARSENAME(REVERSE(REPLACE(REPLACE(REPLACE(fullname, '.',''),',', ''), ' ', '.')), 2)),
	REVERSE( PARSENAME(REVERSE(REPLACE(REPLACE(REPLACE(fullname, '.',''),',', ''), ' ', '.')), 3))
FROM names