select substr('nurhak.kaya_1234', 1, instr('nurhak.kaya_1234', '_') -1) from dual; --result: nurhak.kaya
Solution Architect | Umbraco Certified Master | Umbraco MVPx3 | Certified ScrumMaster
"Anyone can cook, but only the fearless can be great." Ratatouille