Let me ask this follow up if I can. If I wanted to change multiple ProblemTypes to 12 would the code be as follows

update Table1

SET ProblemType = 12

WHERE ProblemType...

Thanks! Not sure where I got the "sub query idea from" but make sense to use just simple coding.

😀