I have a varchar(255) that is a number with sometimes 2 digits and sometimes 3 digits
i need to convert it to a three digit string with a leading zero if its two digits or one digit.
so if it 94 i want it to return 094
if it is 1 I want it to return 001
thanks in advance