Re: How to obtain only xx char

Identity wrote:
> Hi! I've a field varchar2(100)... how can I obtain only the from 4th to
> 7th char??
>
> Thanks

Look up the SUBSTR function in your SQL Reference manual. That will do what you want.

http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14200/functions162.htm#i87066

HTH -g Received on Fri Jul 07 2006 - 09:03:09 CDT