在SQL语句中移除字段中的前导零。

I am working on a SQL query that reads from a SQLServer database to produce an extract file. One of the requirements to remove the leading zeroes from a particular field, which is a simple I am working on a SQL query that reads from a S