i have written below query
why it is not working could you please help me?
select substr(ename,instr(ename,' ',1,1),instr(ename, ' ',1,2)) from e1
first instr function should return first space position and
2 nd instr function should return 2nd space position
so we can specify in substr function to extract the string position form this place to that place
it would be great help if you explain the reason
Best Regards,
Prem kumar