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