Re: Field matching part of a string...need inspiration

You might try a soundex search as a first pass to reduce the set of rows you have to exhaustively interrogate. This assumes you'd be able to add a soundex column to the table, or a new xref table with soundex values. In article <6p63mo$62b$1@nnrp1.dejanews.com>, mjgator@sibretown.com wrote: > I have a table with a list of names to be weeded out of file 'A'. As I > proceed through File 'A', I read each name into a variable, 'pname.' 'Pname' > needs to be checked against the entries in the table to make sure it does not > exist in any form. For example, the name in my file is "George of the > Jungle." In my lookup table, I have 'George' as an entry, so that listing in > file 'A' should be tossed. Every permutation I've tried of like, match, or = > is either too slow or produces incorrect results. Any brainstorms on this? > > -----== Posted via Deja News, The Leader in Internet Discussion ==----- > http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum > -- Dennis J. Pimple Principal Consultant Informix Software Inc. -----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum