/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 vote347 views1 answer
Sql alchemy escape ; in insert statement
SQL
0 vote345 views1 answer
Loop through a table variable in TSQL without using a cursor
SQL
0 vote342 views1 answer
Sqlcmd xml output insert line break after every 2033 characters
SQL
12 votes349 views3 answers
Install sqlite driver ubuntu
SQL
24 votes332 views2 answers
Alter table delete column
SQL
0 vote393 views1 answer
Install mysql on bash
SQL
18 votes331 views6 answers
Create table mysql
SQL
0 vote333 views1 answer
Postgres sql alter table delete row
SQL
0 vote348 views1 answer
USING THE NOT CONDITION IN SQL
SQL
0 vote367 views1 answer
Is not numeric sql
SQL