SQlserver创建函数实现只取某个字段的数字部分

[sql] 
set ANSI_NULLS ON  
set QUOTED_IDENTIFIER ON  
go  
  
ALTER FUNCTION [dbo].[GET_NUMBER](@S VARCHAR(100))  
RETURNS VARCHAR(100)  
AS  
BEGIN  
WHILE PATINDEX('%[^0-9]%',@S) >





 0  
BEGIN  
set @s=stuff(@s,patindex('%[^0-9]%',@s),1,'')  
END  
RETURN @S  
END  
[sql] 
select dbo.GET_NUMBER('你好111犊子')