Field scan question - PL/SQL trigger

From: <Jim.Pickett_at_cubic.com>
Date: 1998/01/14
Message-ID: <Forum.884821104.31171.Pickett@ferret.corp.cubic.com>#1/1

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 Wed Jan 14 1998 - 00:00:00 CST