By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| NAME_SURNAME | SUBSTR(NAME_SURNAME,1,INSTR(NAME_SURNAME,'')-1) |
|---|---|
| John Smith | John |
| Tim Burton | Tim |
| Harry Potter | Harry |
| NAME_SURNAME | SUBSTR(NAME_SURNAME,1,INSTR(NAME_SURNAME,'')-1) |
|---|---|
| John Smith | John |
| Tim Burton | Tim |
| Harry Potter | Harry |