CREATE FUNCTION [dbo].[RemoveLeadingZeros] (@Input VARCHAR(256))
RETURNS VARCHAR(256)
AS
BEGIN
RETURN
(SELECT CASE WHEN Pindex >0 THEN SUBSTRING(LInput, Pindex, LEN(LInput) - Pindex + 1) END
FROM (SELECT LTRIM(@Input) AS LInput) a
CROSS APPLY (SELECT PATINDEX('%[^0]%', LInput) AS Pindex)b
)
END