I have to update a column in a table based on the value of another column in the same table.
col A holds the varchar value of a number
col B is the range of that number
if col A = '30' then col B needs to be updated to '30-40'
if col A = '50' then col B needs to be updated to '50-100'