Mega Code Archive
Categories
/
MSSQL Tutorial
/
String Functions
Prefixing a Numeric Value with Zeros
RIGHT (REPLICATE ('0', 10) + CAST (qty AS varchar (10)), 10)