Access Format Equivalent

Hello:
What would the equivalent syntax be to format the
following in SQL as can be done in Access.
Format("000000",employee) to return 012345 from 12345
CREATE TABLE #Temp
(
Employee CHAR(6)
)
INSERT INTO #Temp VALUES ('1')
INSERT INTO #Temp VALUES ('12')
INSERT INTO #Temp VALUES ('123')
INSERT INTO #Temp VALUES ('1234')
INSERT INTO #Temp VALUES ('12345')
SELECT * FROM #Temp
SELECT REVERSE(LEFT(LTRIM(REVERSE('000000'+ Employee)),6))
FROM #Temp
Rohtash Kapoor
http://www.sqlmantra.com
"Bryan" <anonymous@.discussions.microsoft.com> wrote in message
news:1c02d01c45186$9f7810d0$a001280a@.phx.gbl...
> Hello:
> What would the equivalent syntax be to format the
> following in SQL as can be done in Access.
> Format("000000",employee) to return 012345 from 12345
>
|||Thanks for the reply, but I think I found a simpler way.
select right('000000' + convert(varchar,
employee_number), 6)

>--Original Message--
>CREATE TABLE #Temp
>(
> Employee CHAR(6)
>)
>INSERT INTO #Temp VALUES ('1')
>INSERT INTO #Temp VALUES ('12')
>INSERT INTO #Temp VALUES ('123')
>INSERT INTO #Temp VALUES ('1234')
>INSERT INTO #Temp VALUES ('12345')
>SELECT * FROM #Temp
>SELECT REVERSE(LEFT(LTRIM(REVERSE('000000'+
Employee)),6))
>FROM #Temp
>--
>Rohtash Kapoor
>http://www.sqlmantra.com
>"Bryan" <anonymous@.discussions.microsoft.com> wrote in
message
>news:1c02d01c45186$9f7810d0$a001280a@.phx.gbl...
>
>.
>