sscc padding asn
SELECT LEN('16790000022722') --14
SELECT 17 - LEN('16790000022722') --3
SELECT REPLICATE('0', 17 - LEN('16790000022722')) --000
SELECT STUFF('16790000022722', 1, 0, REPLICATE('0', 17 - LEN('16790000022722'))) --00016790000022722
SELECT [dbo].[fnGetSSCC](STUFF('16790000022722', 1, 0, REPLICATE('0', 17 - LEN('16790000022722')))) --000167900000227220