Community Learn Tools Library Leisure
search
English
Home > Database > Mysql Tutorial > 去掉前面的0的sql语句（前导零，零前缀）

去掉前面的0的sql语句（前导零，零前缀）

WBOY
Release： 2016-06-07 18:02:04
Original
5294 people have browsed it

一个列的格式是单引号后面跟着4位的数字，比如’0003,’0120,’4333，我要转换成3,120,4333这样的格式，就是去掉单引号和前导的0，用以下语句就可以。

原来sql还有个stuff的函数，很强悍。

一个列的格式是单引号后面跟着4位的数字，比如'0003,'0120,'4333，我要转换成3,120,4333这样的格式，就是去掉单引号和前导的0，用以下语句就可以。

SELECT stuff(substring([当前组织],2,4),1,patindex('%[^0]%',substring([当前组织],2,4))-1,''),人员编码

FROM dbo.orgusermap$

where 人员编码 is not null
Related labels：
remove
source：php.cn
Previous article：sqlserver 三种分页方式性能比较[图文] Next article：win2003安装sqlserver 2000提示无法验证产品密钥的解决方法
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
The query and formula form the entire table, with new columns, where the new columns are formulas involving other conditional column values EDIT: The formula should be the "value" column - the "value" column wi...
From 2024-04-06 21:23:40
0
2
530
Sudoku checker not working? Can anyone help me identify the error? I tried everything on the online editor but still get the error. But when I do this on VSC...
From 2024-04-06 21:21:07
0
1
474
Why does omitting 0ms sleep break my css transitions? I'm trying to implement a FLIP animation to see if I understand it correctly. In this code...
From 2024-04-06 16:29:50
0
2
490
Using Case to subtract price in Mysql I have 3 tables: training_schedules, training_discounts and agents. training_schedules: id...
From 2024-04-05 11:18:53
0
1
352
Angular 7 remove duplicate attributes in SCSS AngularSASS (.scss) strips properties. How do I prevent this from happening so I can embed...
From 2024-04-04 23:28:54
0
1
1382
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template