Culling records with Key words

  • Thread starter Thread starter James K via AccessMonster.com
  • Start date Start date
J

James K via AccessMonster.com

I'd like to create a VB module that looks at the table [fullnames] and
deletes records that match in another table [badwords]. Basically, I'm
trying to cull any records that are business related. The string in the
[badwords] table has such things as Corp, Co, Inc, Inc. etc. I'm limited to
1024 characters using the NOT Like "*XYZ*" in the build portion of the query
and 2048 to the SQL portion. The [badwords] table is much more extensive
than that, so thought a VBA modules might work instead.

I'm open to any and all suggestions though.

Regards,
Jim
 
I'd like to create a VB module that looks at the table [fullnames] and
deletes records that match in another table [badwords]. Basically,
I'm trying to cull any records that are business related. The string
in the [badwords] table has such things as Corp, Co, Inc, Inc. etc.
Click to expand...

delete from fullnames
where fullnames.id in
( select f.id
from fullnames as f, badwords.b
where fullnames.names like "*" & b.wordtext & "*"
)
I'm limited to 1024 characters using the NOT Like "*XYZ*" in the build
portion of the query and 2048 to the SQL portion.
Click to expand...

I don't understand this. What limit is there on a SQL query? If there is
one, I assumed it would be 32K, the same as a VB String.

Hope it helps

Tim F
 
Back
Top