Oh right. I didn't know that. Thanks!!

Yeah I see what you mean.

The only reason I used IN is because I actually had an INNER JOIN (I was testing for a certain condition using another related Table)....

Thanks for the quick response guys.

I had *just* found a way before the suggestions. I used the following:

update Table

set ColumnName = SUBSTRING(ColumnName , 5, (LEN(ColumnName)-4))

where PrimaryKeyColumn in

(

select t.PrimaryKeyColumn...