Pages

Wednesday, August 21, 2013

SQL SERVER – UDF – User Defined Function to Extract Only Numbers From String | Journey to SQL Authority with Pinal Dave

Following SQL User Defined Function will extract/parse numbers from the string. CREATE FUNCTION ExtractInteger(@String VARCHAR(2000)) RETURNS VARCHAR(1000) AS BEGIN DECLARE @Count INT DECLARE @IntNumbers VARCHAR(1000) SET @Count = 0 SET @IntNumbers = '' WHILE @Count <= LEN(@String) BEGIN IF SUBSTRING(@String,@Count,1) >= '0' AND SUBSTRING(@String,@Count,1) <= '9' BEGIN SET @IntNumbers = @IntNumbers + SUBSTRING(@String,@Count,1) END SET… Continue Reading...

Source: SQL SERVER – UDF – User Defined Function to Extract Only Numbers From String | Journey to SQL Authority with Pinal Dave

No comments:

Post a Comment