/SQL/Split first name and last name in sql

Split first name and last name in sql

# Name of table = names_table
# Name of column containing names = full_name
# Simply change the table and column name to what corresponds with your dataset

SELECT LEFT(full_name, STRPOS(primary_poc, ' ') -1 ) AS first_name,  
  		RIGHT(full_name, LENGTH(primary_poc) - STRPOS(primary_poc, ' ')) AS last_name, name
FROM names_table;

# NB: This does not capture middle names

Similar codes

0 vote181 views1 answer
SQL Error 1040 : Too many connections
SQL
2 votes185 views2 answers
How to add not null constraint in sql
SQL
1 vote186 views1 answer
Find difference in dates sql
SQL
1 vote217 views1 answer
Select not matching data with join table
SQL
0 vote157 views3 answers
Sql server obtener fecha en formato dd/mm/yyyy
SQL
13 votes166 views6 answers
Current date sql
SQL
0 vote158 views1 answer
Update if else mysql
SQL
0 vote173 views1 answer
Convert excel into sqllite db using python
SQL
18 votes187 views3 answers
Mysql add column default value
SQL
0 vote161 views1 answer
Get week day name sql server
SQL