SQL Server String Manipulation 1

[marcoman44]

I am trying to accomplish the following:

Field1
123456
12345678

I want the string to look like this through a query in SQL Server(Always 8 characters + *01)

00123456*01
12345678*01

In Access I am able to accomplish this through the Format Function, but this is not available in SQL Server.
Any help is greatly appreciated.

Thanks

 

[SonOfEmidec1100]

One way

--field1 numeric

select right('00000000' + convert(varchar(8),field1),8) + '*01'

--field1 varchar/char

select right('00000000' + rtrim(field1),8) + '*01'