>>I need to padlef a string with zeros in TSQL, but I can't find the command.
>>42 -> 0042
>>
>>Any help would be appreciated.
>>
>>Thanks,
>>Einar
>
>

>SELECT RIGHT('0000'+CAST(42 as varchar(4)), 4)
>

Thanks. Makes a lot of sense.