将列中的值乘以100，基于另一列的值，引用表

I have a table that has the fields (columns) Account Number, Name, and Balance. For any account numbers beginning with "100", the corresponding balance must be multiplied by 100.I have a table that has the fields (columns) Ac