I needed my value to be 8 characters long; and if it wasn’t that, the first few should be “0” until there were 8 characters. You can use the REPLICATE() and RIGHT() functions. Here’s the SQL: SELECT
employeeIdAsText,
RIGHT(REPLICATE('0', 8) + employeeIdAsText, 8) AS employeeIdPadded
FROM dbo.Employees