how to find particular char in entire field ?

[kunal30doshi]

hi,

i want to find particular char. from entire char. field within given range.

Ex Field x is 10 char field and it's value is YYYYNNNNYY.

i want to know if n is exist in this field withing given range.

[milonov]

hi

you can use pl/sql function named "instr" that
returns the location of a substring in a string

for more information see http://www.oraclehome. co.uk/instr-function.htm

Best Regards,
Michael Milonov

http://www.snotratech.com

hi,

i want to find particular char. from entire char. field within given range.

Ex Field x is 10 char field and it's value is YYYYNNNNYY.

i want to know if n is exist in this field withing given range.