Function to get Only Numeric Value
Please Use this function for that
CREATE FUNCTION dbo.Ravi_GetNumeric
(@CompeteStr VARCHAR(256))
RETURNS VARCHAR(256)
AS
BEGIN
DECLARE @NumericValues INT
SET @NumericValues = PATINDEX('%[^0-9]%', @CompeteStr )
BEGIN
WHILE @NumericValues > 0
BEGIN
SET @CompeteStr = STUFF(@CompeteStr , @intAlpha, 1, '' )
SET @NumericValues = PATINDEX('%[^0-9]%', @CompeteStr )
END
END
RETURN ISNULL(@CompeteStr ,0)
END
0 comments:
Post a Comment