Just wanted to give you a follow-up - while doing a single SELECT with the keywords separated by a ' OR ' is of course much faster/more efficient, ironically...

I assumed it should have been >0 and yes, HTMLBody is the TEXT column within the Email table.

There was an issue with some of the keywords ( this is a...

Thanks again - but still no joy. The join fails - should it not have a comparative after patindex, but even when I added somethingn it cannot match the HTMLBody...

Thank you for the suggestion, but both return: "Incorrect syntax near 'kw'.", pointing to the line with the CONTAINS keyword.

I haven't been able to create a join using CONTAINS.

A full-text index to allow searching. (FT Catalog)

I found this info on: http://www.mydatabasesupport.com/forums/sqlserver-datawarehouse/167557-reclaim-blob-text-field-reserved-space.html

Which indicates that re-importing is the only way to reclaim the space...ack!

No - I am not setting the column to NULL first - wasn't aware that would make a difference - does it?

Text in Row is NOT enabled - just a...

SOUNDEX of course is far from exact - Joe Smith will match Jose Smithers, etc.

The first time the comparison was run, we had a few dozen false positives.

That is why...

A financial services company in Atlanta, GA (The Henssler Financial Group).

I appreciate the offer, but no need - our methdology is customized to our needs and works well.

The OFAC data is imported from the XML file the USTD provides to its own database (multiple tables). The import program drops/recreates the tables each time.

The main identity table (sdnentry)...

I will send him an email with a link to this forum posting and ask him to contact you.

Pablo,

I posted a query on Guru.com and found someone that had already written a C# app to import the XML data into SQL. They gave me a very reasonable quote...

The intent is to prevent it - otherwise, it would cause a recursive loop and prevents our reports from running. That is also why I must include the 'upstream'.

Thank you for the input (and two links) - both very helpful. I recall reading Celko's article a while back, but like the other author find that method a bit...