I need to store a number in my SQL database in the form 0001, 0020, 0134 i.e. fixed at 4 digits. Does anyone have any idea how to do this ? This is a new requirement to an existing system hence i'd rather make a database change if possible ratehr than having to make changes to lots of ASP pages ...

Thanks in advance
Ian.