Split FirstName and LastName from Full Name in SQL

This blog will show how to get firstname and lastname from Full name in SQL (assuming first space separates the full name).

This blog shows how to get first name and last name from full name in SQL.

 

Here We Let's assume First space of full name separates first name and last name. 

 

Query

 

 

Result