>>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.
Great. Thanks.
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com