At 07:20 PM 22/09/2005 -0400, Louis Kleiman wrote:

>Clay -
>
>
>
>I think your INSERT should be:
>
>
>
>INSERT INTO SOUNDEX_PAIRS
>
>(TABLE_NAME, COLUMN_NAME, FKEY, RAW_VALUE)
>
>(SELECT 'CLIENTS', 'FIRSTNAME', CLIENT_ID, FIRSTNAME FROM CLIENTS)

Almost. :-)

INSERT INTO SOUNDEX_PAIRS

(TABLE_NAME, COLUMN_NAME, FKEY, RAW_VALUE)

SELECT 'CLIENTS', 'FIRSTNAME', CLIENT_ID, FIRSTNAME FROM CLIENTS

./hb

p.s. Why don't you just store the soundex directly in the table? You can
populate it with a Before Insert or Update trigger...