[MSSQL] 문자열에서 숫자 추출하기 (0~9)

함수생성

 
 
CREATE  FUNCTION fn_GetOnlyNumber(@Str VARCHAR(512))
RETURNS VARCHAR(512)
AS
BEGIN
DECLARE @retStr varchar(512)
SET @retStr = ''
 declare @i int
 SET @i = 1
   While @i <= Len(@Str)
 BEGIN  
  IF substring(@Str,@i,1) BETWEEN '0' AND '9'
  SET @retStr = @retStr + substring(@Str,@i,1)
  SET @i = @i + 1
 END
RETURN @retStr
END
 
 
 
 
 

-------

사용법

select fn_GetOnlyNumber([컬럼명])
 
from [테이블이름]