|
|
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
Navigation:
[Reply to this message]
|