Split first-name middle-name and last-name from full name using sql query

// using SUBSTRING

declare @name varchar(50)='krishna-chaturvedi'

SELECT top 2 SUBSTRING(@name, CHARINDEX('-', @name)+1, 8000)+'/' +SUBSTRING(@name, CHARINDEX('-', @name) + 1, 8000)

FROM mstuser

// using PARSENAME

declare @name varchar(100)= 'krishna-kumar-chaturvedi'

Select PARSENAME (Replace(@name,'-','.'),1)[LastName],

            PARSENAME (Replace(@name,'-','.'),2) [MiddleName],

            PARSENAME (Replace(@name,'-','.'),3)[FristName]