Any time. :)

>Perfect Sergey!! Just what I was looking for.
>
>Thanks a bunch!
>
>~~Bonnie
>
>
>
>>Simpler one. It's like PADL.
>

SELECT REPLICATE('0', 10-PATINDEX('%[^0-9]%', @StreetNumber + 'A')) + @StreetNumber

>>