Using PARSENAME Function to split First name.Middle name and Last name

PARSENAME function works as Dot Net Split function ,As Split method is used to separate deliminated values and using index we can get value. PARSENAME function works same.
For Example:-

DECLARE @FullName VARCHAR(100)
SET @FullName = 'Vishal Kumar Neeraj'

SELECT PARSENAME(REPLACE(@FullName, ' ', '.'), 3) AS [First_Name],
       PARSENAME(REPLACE(@FullName, ' ', '.'), 2) AS [Middle_Name],
       PARSENAME(REPLACE(@FullName, ' ', '.'), 1) AS [Last_Name]

First_Name Middle_Name Last_Name
Vishal Kumar Neeraj