Re: Drop everything after slash in 'foo/bar' in SQL ?

select substr('foo/bar', 1, instr('foo/bar' || '/', '/') - 1) from dual

Richard

Emmett wrote:
>
> Is it possible to select only the foo part of 'foo/bar'
> in SQL?
>
> How ;-)
>
> Thanks,
>
> em
Received on Fri Aug 30 2002 - 16:26:42 CDT