How to split the full name into FirstName and LastName in SQL server?

Question

Ashutosh Patel · Answer

To split a FullName into FirstName and LastName in SQL Server, you can use string functions like CHARINDEX, LEFT and RIGHT. Here is an example of how you can do this, Assuming you have an SQL table Employees with a column EmpName that contains the name in the format of “FirstName and LastName”, Here is the SQL Query to split the full name into first name and lastname Example-

interview

How to split the full name into FirstName and LastName in SQL server?

Can you answer this question?

1 Answers