interview

Home / DeveloperSection / Interviews / How to split the full name into FirstName and LastName in SQL server?

Ask Question
Ashutosh Kumar Verma

Ashutosh Kumar Verma

Follow
Hi! This is Ashutosh Kumar Verma. I am a software developer at MindStick Software Pvt Ltd since 2021. I have added some new and interesting features to the MindStick website like a story section, audio section, and merge profile feature on MindStick subdomains, etc. I love coding and I have good knowledge of SQL Database.

Can you answer this question?

Answer

1 Answers

Ashutosh Kumar Verma

Ashutosh Kumar Verma

15-Oct-2024

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

SELECT EmpName, LEFT(EmpName, CHARINDEX(' ', EmpName) - 1) AS FirstName,
   RIGHT(EmpName, LEN(EmpName) - CHARINDEX(' ', EmpName)) AS LastName
FROM Employees

 Example-

answer 6518921510075501

 

MindStick Training

Liked By