Posted by Uri Dimant on 11/13/06 08:01

Hi

select right(convert(char(11),cast( cast( @number as char(6) ) + '01' as
datetime ),106),8)



"klabu" <noone_at_gmail_dot_com> wrote in message
news:12lfgcha53al985@corp.supernews.com...
> Hi
>
> how to conert (number) 200611 to string 'Nov 2006' ?
>
> thanks
>

[Back to original message]