/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 vote222 views1 answer
Mysql auto increment in YY-MM-XXX format
SQL
1 vote222 views2 answers
Mysql join two tables
SQL
5 votes220 views1 answer
Oracle columns in all_tables
SQL
0 vote248 views1 answer
Flask sqlalchemy. commit does not save changes
SQL
0 vote230 views1 answer
Capture Image Store Image in Folder and image Path in sqlite Database
SQL
-1 vote189 views1 answer
How to create script to connect to oracle database and run query
SQL
0 vote213 views1 answer
Stop psql server windows
SQL
0 vote222 views1 answer
How to select even id in sql
SQL
3 votes231 views1 answer
Postgresql db owner change
SQL
5 votes232 views2 answers
Sql server check port number
SQL