"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
>

>-----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...
>> 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
>>
>
>
>.