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