Formatting Output

Question

Viewing 2 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Jeremy Kemp SSCertifiable Points: 6754 More actions · Answer 1

Do you want this?

id

00001

00002

00003

?

If so,

select right('00000' + convert(varchar,id), 5)

from ..... etc

Jeremy

Squirrel SSC Enthusiast Points: 187 More actions · Answer 2

SSC Enthusiast

Points: 187

May 1, 2003 at 7:44 am

This worked a treat -- thanks Jeremy