wLkis79t

1CREATE TABLE if not EXISTS users_v1 (id integer PRIMARY key, FIO varchar(20));
2DELETE FROM users_v1;
3INSERT INTO users_v1 (FIO) VALUES ("firstname1 surnamae1 patronimyc1");
4INSERT INTO users_v1 (FIO) VALUES ("firstname2 surnamae2 patronimyc2");
5INSERT INTO users_v1 (FIO) VALUES ("firstname3 surnamae3 patronimyc3");
6--SELECT * FROM users_v1;
7SELECT firstname,
8       substr(surnamae_patronimyc, 1, charindex(' ', surnamae_patronimyc)-1) as surnamae,
9       substr(surnamae_patronimyc, charindex(' ', surnamae_patronimyc) +1) as patronimyc
10  from (
11       SELECT FIO, 
12              substr(FIO, 1, charindex(' ', FIO)-1) as firstname, 
13              substr(FIO, charindex(' ', FIO) +1) as surnamae_patronimyc
14         from users_v1);