/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

1 vote214 views1 answer
Raise application error in oracle
SQL
0 vote195 views1 answer
Use between operator in mysql
SQL
50 votes289 views6 answers
Sql count duplicate rows
SQL
0 vote204 views1 answer
Sql server port 1434
SQL
0 vote198 views1 answer
Adding conditions in MERGE statement in Oracle SQL for INSERT/UPDATE
SQL
0 vote200 views2 answers
Null value in column violates not-null constraint
SQL
2 votes206 views1 answer
Wait delay in sql server
SQL
0 vote200 views1 answer
Tsql default value when no value returned by query
SQL
3 votes240 views1 answer
Sql double index
SQL
0 vote221 views1 answer
Python list from sql
SQL