Updating data

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.

Try it,

you can use restrict update clause by putting more conditions in where clause.

update dbo.runners set id=replace(id,'a','1') where charindex('a',id)>0