By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE mytable(
full_name VARCHAR(100) NOT NULL
);
INSERT INTO mytable(full_name) VALUES ('fred flintstone');
1 rows affected
select * from mytable
| full_name |
|---|
| fred flintstone |
alter table mytable
add
first_name varchar(100)
, last_name varchar(100)
update mytable
set
first_name = LEFT(Full_Name,CHARINDEX(' ',Full_Name )-1)
, Last_Name = RIGHT(Full_Name, LEN(Full_Name)- CHARINDEX(' ', Full_Name))
1 rows affected
select * from mytable
| full_name | first_name | last_name |
|---|---|---|
| fred flintstone | fred | flintstone |