Update 3rd Char In a Text Field 1

[AshleyRickards]

Been a while trying to do this. Must be brain dead today.

Need to update the 3rd character in a 5 character text string.

Something like this:
update products
set (select left(productname, 2) from products))) = 'X'

TIA


Ashley L Rickards
SQL DBA

 

[vongrunt]

update product
set productname = STUFF(productname, 3, 1, 'X')