gemma-l
2/28/2018 - 9:34 AM

sscc padding asn

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