Solved

Ok, it is working exactly how I want! Thanks so much!!!

Thanks, I believe this is exactly what I'm looking for. Yes, I always backup and run my tests on a "Test" database before implementing any changes. I'm sorry, I should...

@ Lowell

Works perfectly! I appreciate you trying to look out for me by using those extra safeguards - very nice of you.

What do I need to change to get the...

@Lowel

Thank you for the advice, but creating a view that features the calculation, or adding a persisted calculated column to my table won't really serve its purpose in my situation....

@Bitbucket

IM_PRC is the name of the table. When using the statement you provided, I get the following error:

Msg 156, Level 15, State 1, Line 2

Incorrect syntax near the keyword 'SELECT'.

Msg...

That list of items was only a sample list. I have over 100,000 items, and they are changing fairly often. Will this only work if I can past my entire...

Worked perfectly. Thank you so much!