We were creating a extract at work from T-SQL and new that the we would need to export data with leading zeros. The data was not stored in the database with those leading zero values. The solution, create a simple scalar function to dynamically add the zeros that could accept two parameters ( text , and total length).
The Function is rather simple takes the total length value passed by the user and then subtracts the Length of the the text value.
What would make this better?
- Would have a default value for total length
- Error checking to make sure the text supplied is not longer than the total length