Hello again, ive got a table with a column that normally contains a number,
for example, 4057. But there are some that finishes with an a, for example,
4057a. I want to quit the "a" and place a "1" instead, so in the last
example, the 4057a will be a 40571.

The column name is called ID and the table name is called dbo.runners

Many thanks.