Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to cut a field in oracle

Re: How to cut a field in oracle

From: <fitzjarrell_at_cox.net>
Date: 11 Jan 2006 17:11:50 -0800
Message-ID: <1137028310.780085.302390@g49g2000cwa.googlegroups.com>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US