/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

8 votes242 views1 answer
Oracle search code in packages
SQL
3 votes156 views1 answer
Oracle nextval
SQL
0 vote167 views1 answer
Sql server count all tables rows
SQL
0 vote159 views1 answer
Join creating duplicate columns sqllite
SQL
1 vote201 views1 answer
Encrypt password postgresql
SQL
0 vote181 views1 answer
Sql grant select only
SQL
2 votes177 views1 answer
Sql server check for value in multiple columns
SQL
17 votes176 views3 answers
How to change a collumn name in sql
SQL
5 votes212 views4 answers
Mysql on duplicate key update
SQL
0 vote175 views1 answer
How get data from database if id not found then search another column
SQL