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

How about a SQL unload of the table's data to a file and a simple awk script that'd walk thru the records and do what you want completely outside of the database? If you have a third party tool like Syncsort, something like this would fly because they use a hashing mechanism. Arun 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