If I were doing this one at a time like the below, where could I use the REPLACE that would work with a series like below?:

UPDATE dbo.List with (ROWLOCK) SET Dimensions = '4.1x0.5'

WHERE [ID] = 32275124 and Dimensions = '4.1x.5'

could I use something like this:

UPDATE dbo.List with (ROWLOCK) SET Dimensions = REPLACE(diminsions,'x.','x0.')