Re: Field scan question - PL/SQL trigger

try instr function
instr(string,character-or-string-that-you-want-to-search). instr will return the position where the string is found. If not found, it returns 0.

Jim.Pickett_at_cubic.com wrote in article
<Forum.884821104.31171.Pickett_at_ferret.corp.cubic.com>...
>
> Dear PL/SQL Gurus:
>
> I have been asked to develop a trigger that will allow me to parse
> a VARCHAR2(30) field to see if it contains an asterisk or double
> quote.
>
> The existence of either of these two characters within the field is
> causing an application error in our CODA A/P system.
>
> Is there a syntax or function that will allow me to inspect the entire
> field for the existence of these specific characters.
>
> We are using PL/SQL version 2.3 if it matters.
>
> Please reply to my e-mail below as well as the board as I don't get the
> opportunity to "visit" as frequently as i'd like.
>
> Thanks in advance.
>
> ======================================
> Jim Pickett
> Cubic Corporation
>
> Work: (619)505-2868
> Pager: (619)494-5539
> E-mail: jim_pickett_at_cubic.com
>
> 01/14/98 15:32:17
> ======================================
>
>
>
Received on Fri Jan 16 1998 - 00:00:00 CST