I want to be able to search by soundex, and keep the soundex vals in a
separate table, a la a "Code Table".



I want to be able to query this table if an exact match search fails, like
this:



SELECT FKEY FROM SOUNDEX_PAIRS WHERE (TABLE_NAME = :TableName) AND
(COLUMN_NAME = :ColName) AND (SOUNDEX_VALUE = :SoundexVal)



This doesn't work to popul8 the table with one set of values:



INSERT INTO SOUNDEX_PAIRS

(TABLE_NAME, COLUMN_NAME, FKEY, RAW_VALUE)

VALUES

('CLIENTS', 'FIRSTNAME', SELECT CLIENT_ID, FIRSTNAME FROM CLIENTS)



I can always pump the data in using DBWB, but is there a way to do it using
SQL?



Clay Shannon,

Dimension 4 Software





[Non-text portions of this message have been removed]