从 SQL 语句中的字段中删除前导零 [英] Removing leading zeroes from a field in a SQL statement

问题描述

我正在处理从 SQLServer 数据库读取以生成提取文件的 SQL 查询.从特定字段中删除前导零的要求之一，这是一个简单的 VARCHAR(10) 字段.因此，例如，如果字段包含00001A"，则 SELECT 语句需要将数据返回为1A".

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 VARCHAR(10) field. So, for example, if the field contains '00001A', the SELECT statement needs to return the data as '1A'.

SQL 中有没有办法以这种方式轻松删除前导零?我知道有一个 RTRIM 函数，但这似乎只是删除空格.

Is there a way in SQL to easily remove the leading zeroes in this way? I know there is an RTRIM function, but this seems only to remove spaces.

推荐答案

select substring(ColumnName, patindex('%[^0]%',ColumnName), 10)

这篇关于从 SQL 语句中的字段中删除前导零的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！