/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

1 vote142 views1 answer
Mysql select update same table
SQL
3 votes155 views2 answers
Oracle apex view logs
SQL
5 votes153 views1 answer
Oracle asynchronous update
SQL
-1 vote152 views1 answer
Spring boot mysql connection properties
SQL
0 vote146 views1 answer
Sql server separar numeros por comas miles
SQL
1 vote176 views1 answer
How to get alternate records from a table in sql
SQL
-1 vote139 views1 answer
Ssms connect with connection string
SQL
1 vote146 views1 answer
Tsql get beginning of year
SQL
0 vote151 views1 answer
Sql server list table sizes
SQL
1 vote163 views1 answer
Top 10 rows in mysql
SQL