CREATE FUNCTION Del_Char(@s varchar(100)) RETURNS VARCHAR(100) BEGIN while patindex('%[^0-9]%',@s)>0 begin SELECT @s=stuff(@s,patindex('%[^0-9]%',@s),1,'') end RETURN @s END
posted on 2014-03-25 09:46 29882942 阅读(168) 评论(0) 编辑 收藏 举报
Powered by: 博客园 Copyright © 2024 29882942 Powered by .NET 8.0 on Kubernetes