To update a table you need an UPDATE statement, not SELECT.

I don't understand the purpose of a CASE expression with 1=1 as the condition?  That condition will always evaluate as True and therefore you don't need CASE at all.
Select material_id, material_description, diameter = diameter / 25.4, wall_thickness = wall_thickness / 25.4 From MaterialTable

John