SQL function that removes the leading zeros from string

funRemoveLeadingZeros.sql

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		Vikas Patel
-- Create date: 01/31/2019
-- Description:	Remove leading zeros from string
-- =============================================
CREATE FUNCTION dbo.funRemoveLeadingZeros 
(
	-- Add the parameters for the function here
	@Input varchar(max)
)
RETURNS varchar(max)
AS
BEGIN
	-- Declare the return variable here
	DECLARE @Result varchar(max)

	-- Add the T-SQL statements to compute the return value here
	SET @Result = @Input

	WHILE LEFT(@Result, 1) = '0'
	BEGIN
		SET @Result = SUBSTRING(@Result, 2, LEN(@Result) - 1)
	END

	-- Return the result of the function
	RETURN @Result

END
GO