通过从SQL Server数据库的列中的数值中仅删除一个前导零来更新表的最佳方法是什么

Currently, I have a column with 10 digits with leading '0' on all the records and I want to remove that '0' and keep 9 digits only even if it's start with a zero. I want to later join that table with another table in that column and the other table has 9 digits on all record and some start with 0.Currently, I have a column with 10 digits with