How to get the substring value from a column with data?

[ddrozdov]

SELECT
substr(fullnames,1,1)||substr(fullnames,instr(fullnames,' ')+1,1) initials
FROM
names