/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 vote300 views1 answer
Which takes more space in a database a datetime or separate date and time columns?
SQL
1 vote270 views1 answer
Truncate table in postgresql and reset id
SQL
0 vote311 views1 answer
Sql server user permissions and roles
SQL
5 votes298 views3 answers
Sql max value in column
SQL
0 vote290 views1 answer
How to open mysql in docker
SQL
2 votes290 views1 answer
Drop table purge
SQL
22 votes300 views3 answers
SQL CHEATSHEET
SQL
0 vote343 views1 answer
Pl sql join 3 tables
SQL
0 vote337 views1 answer
How to check rollback status in oracle
SQL
0 vote287 views1 answer
Which MySQL data type to use for storing boolean values
SQL