How query the SQL statement by the output is leading 0

[EngJoo]

Greeting,

i face a difficulties on query the output in leading 0.

for example:

my customer number =1234

for instant i declare customer char(10)

then i wish my query output is 0000001234(leading Zero)

Does anyone can provide me the SQL Script on how to do that?

Thank you.

 

[tb]

Don't know what your query looks like, but you could try this ...

select RIGHT('0000000000' + CustomerField,10) AS 'Customer'

I was standing in the park, wondering why frisbees got bigger as they came closer... then it hit me!