How do you perform SOUNDEX queries in Forms Query Mode?

From: Enzo Maini <emaini_at_sikorsky.com>
Date: 1995/12/13
Message-ID: <9512122143.AA22785_at_enzomc>#1/1

Does anyone have any experience in using SOUNDEX with Forms 4.0. Users would like to enter the following for the query:

<Customer Name> : SOUNDEX('Jones')

The proper use of SOUNDEX within Oracle is

SELECT first_name, last_name, company_name   FROM emp
 WHERE SOUNDEX(last_name) = SOUNDEX('Jones');

This is a cool way to find misspellings.

If you put the following in a field:

#SOUNDEX('Jones')

You get an error, because Oracle Forms writes the SQL as such:

SELECT first_name, last_name, company_name   FROM emp
 WHERE last_name SOUNDEX('Jones');

You could use a field variable like :LN
but then the user would have to type

SOUNDEX('LAST_NAME') = SOUNDEX('Jones')

Which seems unreasonable because now each user would need to know the attributes of the table query on fields.

Does anybody have any good ideas?

(Seems like Oracle should have scanned for this operator like it does for the
'Like' operator and performed the proper query--Oh well!)

---

Enzo Maini
Sr. S/W Eng./Sr. Oracle DBA
United Technologies-Sikorsky Aircraft Corporation
(203) 386-7411

email: emaini_at_sikorsky.com Received on Wed Dec 13 1995 - 00:00:00 CET