Sergiy you are right again! The data changes, but not so much that I cant run a process every night/week and create a table of distinct full descriptions, and...

You asked "so with two separate tables how did it get determined to compare 'SAMSUNG L900 SILVER vs SAMSUNG N930P BLK KIT ' ?

or is the OP intending to compare...

Very slick, I like it. I was using the priority as a group priority. the random words are group 1, the manufacture was group 2 and...

this is what I can do. I can write some sql, that will produce some tsql alter statement to a function that is driven by the bad words...

I do not. I would have to build the list from the data on a regular basis since I would not know when they are going to slip in...

This is how I delete many millions row a bite at a time. it seem works very well. however you will have see what 'number' your server...

this was my solution

RIGHT('0000000000' + CONVERT(VARCHAR,CONVERT(BIGINT, CONVERT(VARBINARY(4), LEFT(serial_number_dec,8)), 2)),10) +

RIGHT('00000000' + CONVERT(VARCHAR,CONVERT(BIGINT, CONVERT(VARBINARY(4), SUBSTRING(serial_number_dec,9,6), 2)),8),8)

the table is created once a day.

it is a table.

Also I cannot install third party apps. it has to be SQL to find the problem. old school

can the article be reposted with all the corrections? it will be easier for anyone in the future...........

Where will the corrected code be placed? Will it be reposted? The articles topic and goals interested me, but the problems trying to get it to...

ok, you are right. At the time I was swamped and trying to fix the next dozen problems on my list. I cant find my link to...

ok, I give up. I defer to everyone greater judgement in the matter. Make perfect sense. I have created table......thank you for the help.

in the...

getting

Server: Msg 208, Level 16, State 1, Line 1

Invalid object name 'Tally'.

if there is a way to it without a table, I would like to know how