Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to cut a field in oracle
balu422_at_yahoo.com wrote:
> Hi Everyone,
>
> I am using oracle 8i and I have a table called ge_module_access which
> has a field name called functions. functions field has values like
> 'NNNNNNYNNNYNYYYY'
> 'YYYNNNYYYNNNNNYY'
> 'YYYYYYNNNNNNYYYY' etc
> each character means something is there a way I can
> cut this field in the where clause?
> select * from ge_module_access
> where first character of field functions is 'Y';
> which should bring up 2nd and 3rd record in the
> example above.
> BTW I need to cut the field instead of using like.
> Example:
> if 'YYNNYY' is function_id 1, 2 and 5, 6.
> if 'NNYYNN then funcion_id 3 and 4 and so forth....
> Any help to accomplish the task is appreciated.
> Thanks,
>
> Balu
Use SUBSTR():
substr(functions, 1, 1) = 'Y'
for example, would provide the results you want in your example.
David Fitzjarrell Received on Wed Jan 11 2006 - 19:11:50 CST