/SQL/Get first name and last name from full name string in SQL

Get first name and last name from full name string in SQL

DECLARE @FullName    VARCHAR(50) = 'Mark Zuckerberg'

SELECT SUBSTRING(@FullName, 1, CHARINDEX(' ', @FullName) - 1) AS [First Name],
       SUBSTRING(@FullName, CHARINDEX(' ', @FullName) + 1, LEN(@FullName)) AS [Last Name]

Source: sql-server-helper.com

Similar codes

0 vote121 views2 answers
What is the default password for sql server sa
SQL
0 vote149 views1 answer
AddEntityFrameworkSqlite
SQL
0 vote123 views1 answer
No query unable to fetch row sqlite
SQL
0 vote107 views2 answers
The metadata storage is not up to date, please run the sync-metadata-storage command to fix this issue.
SQL
21 votes107 views1 answer
SQL cheat sheet pdf
SQL
1 vote116 views1 answer
Print all records of table in mysql
SQL
0 vote113 views1 answer
Sql xampp gabungan nama awal dan akhir
SQL
1 vote127 views1 answer
Insert value to new table by joining 2 different tables
SQL
0 vote116 views1 answer
MySQL - How to find word with the most similar beginning
SQL
1 vote132 views1 answer
Ora-01109 database not open in oracle 19c
SQL