I have a field in an SQL table containing the number of the month.
I want to format this data in a query to a two position text field.
When I use the STR function it returns the value for the month of January as '1'. I want to return the value as a two character field with a leading zero ('01'). In MS Access I would use FORMAT(monthfield,"00"). Is there a function for doing this in SQL?