Listing 2: Query That Converts Value to Char Data Type (goes with Tip 1)
SELECT
	CASE LEN(DATEPART(m,@Testdate))
		WHEN '1' THEN '0' + CONVERT(char(1),
             DATEPART(M, @Testdate))
		WHEN '2' THEN CONVERT(char(2),
             DATEPART(M,@Testdate))	
	END