/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

4 votes312 views1 answer
What are the data types
SQL
0 vote271 views1 answer
Postgresql if else endif
SQL
5 votes294 views2 answers
Mysql create database charset utf8mb4
SQL
1 vote283 views2 answers
Oracle 18c xe ORA-65096
SQL
1 vote262 views1 answer
Oracle list datafiles in tablespace
SQL
0 vote301 views1 answer
Databricks install odbc driver connect to sql server
SQL
2 votes304 views1 answer
Dbms transaction (psql)
SQL
7 votes304 views2 answers
Mysql check db size
SQL
0 vote276 views1 answer
Mysql changer nom table
SQL
0 vote294 views1 answer
Contraint default SQL
SQL