I have a numeric field that is 2 long so it has values like 1,2,55, etc, I want to convert it to a character field and then concatante a string onto into. For the numeric portion I would like it to keep the leading zeros so it wuld be 01 , 02 etc. When I use the convert or the cast function it just convert it to 1,2 =. Is there some function or option that would convert it to 01 instead? I need the leading zero so that it will sort the char field properly.