create function dbo.kkGetNoFromStr(@str nvarchar(100))
--说明字段中排除南风、东北风
returns varchar(100)
as
begin
while patindex('%[((?!.*(南风|东北风)).)*$]%',@str)>0
begin
set @str=stuff(@str,patindex('%[((?!.*(南风|东北风)).)*$]%',@str),1,'')
end
return convert(varchar(100),@str)
end
create function dbo.GetNoFromStr(@str nvarchar(100))
--只提取数字部分
returns bigint
as
begin
while patindex('%[^0-9]%',@str)>0
begin
set @str=stuff(@str,patindex('%[^0-9]%',@str),1,'')
end
return convert(bigint,@str)
end