/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 vote229 views1 answer
Mysql last friday of current month
SQL
0 vote248 views1 answer
Sql from null to not null
SQL
0 vote207 views1 answer
Reset keys in sql
SQL
0 vote268 views1 answer
How to get number of months between 2 dates sql server
SQL
1 vote201 views1 answer
How to ckeck that email is present in databse in mysqli
SQL
0 vote263 views1 answer
BigQuery Remove Duplicate Keys From Table
SQL
0 vote207 views1 answer
Oracle list partitions
SQL
1 vote185 views3 answers
How to truncate foreign key constraint table
SQL
1 vote202 views3 answers
Reset sql primary key
SQL
0 vote200 views1 answer
How to create a table based on another table in mysql
SQL