>It doesn't work because I have to CAST to be able to concatenate the / (and the cast erase the 0).
OK... let's try again. This works for me:
SELECT convert(char(7),convert(datetime,TB.Date),111)
...
It returns yyyy/mm (i.e. '2001/05')
Hope it works for you.
Andres M. Chiriboga, MCSE, MCP+I
