Posted by duprejonathan on 02/13/07 09:36

On 12 fév, 22:17, "Plamen Ratchev" <Pla...@SQLStudio.com> wrote:
> ...it has been a long day already :)
>
> On the last one you do not need the extra CAST:
>
> SELECT RIGHT('0000' + CAST(1 as varchar), 4)
>
> or,
>
> SELECT RIGHT('0000' + CAST(code as varchar), 4) FROM Employes
>
> Plamne Ratchevhttp://www.SQLStudio.com

Thank you very much !!!!!!! Its works.

Jonathan

[Back to original message]