Dwain,

I appreciate your interest and effort on this. I would like to find a more efficient way to handle this but after changing the ITEM1 and ITEM2 to the appropriate column names and changing @T1 to my actual table name I get these errors;

Msg 102, Level 15, State 1, Line 18

Incorrect syntax near '='.

Msg 156, Level 15, State 1, Line 29

Incorrect syntax near the keyword 'WHERE'.

Msg 156, Level 15, State 1, Line 34

Incorrect syntax near the keyword 'WHERE'.

I will try to get back to this this afternoon but thought I owed you a response.