/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 vote341 views1 answer
Get date ISO in psql
SQL
0 vote343 views1 answer
Sql put two columns into one
SQL
1 vote328 views1 answer
Oracle convert run duration to number
SQL
0 vote376 views2 answers
What is rownum in oracle
SQL
5 votes351 views1 answer
Oracle add time to date
SQL
2 votes321 views1 answer
Oracle index size calculation
SQL
0 vote340 views1 answer
Every Derived yable must have its own alias
SQL
0 vote326 views1 answer
How to close external sql connection in laravel
SQL
0 vote353 views1 answer
Postgresql check total storage
SQL
0 vote337 views1 answer
Sql server beginning of month
SQL