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
>

• Next in forum: Re: Please Help With Complex Update Statement Logic
• Prev in forum: Re: 200611 to string 'Nov 2006'
• Thread view: Re: 200611 to string 'Nov 2006'

[Reply to this message]