Thanks Steve,

We have many other non-numeric values like this in the table, we can not run the update statement.

Regards,

Sri