sql extract numbers from string

rawand-faraidun answered on March 16, 2022 Popularity 9/10 Helpfulness 5/10

answer sql extract numbers from string

sql extract numbers from string

Comment

CREATE FUNCTION dbo.udf_GetNumeric
(
  @strAlphaNumeric VARCHAR(256)
)
RETURNS VARCHAR(256)
AS
BEGIN
  DECLARE @intAlpha INT
  SET @intAlpha = PATINDEX('%[^0-9]%', @strAlphaNumeric)
  BEGIN
    WHILE @intAlpha > 0
    BEGIN
      SET @strAlphaNumeric = STUFF(@strAlphaNumeric, @intAlpha, 1, '' )
      SET @intAlpha = PATINDEX('%[^0-9]%', @strAlphaNumeric )
    END
  END
  RETURN ISNULL(@strAlphaNumeric,0)
END
GO

//////////

USAGE:
SELECT dbo.udf_GetNumeric(column_name) 
from table_name

Popularity 9/10 Helpfulness 5/10 Language sql

Source: stackoverflow.com

Tags: extract numbers sql string

Link to this answer
Share Copy Link

Contributed on Mar 16 2022

rawand-faraidun

0 Answers Avg Quality 2/10

sql extract numbers from string

Contents

More Related Answers

sql extract numbers from string

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.