sql string operation: take substr before first comma

SELECT SUBSTR('abc,def,ghi', 1 ,INSTR('abc,def,ghi', ',', 1, 1)-1)
FROM DUAL;


stolen from: 
http://psoug.org/reference/substr_instr.html