Padding data - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

Padding data

Author

Topic

Robwhittaker
Yak Posting Veteran

85 Posts

Posted - 2001-06-29 : 06:50:34

I'm sure this is very simple.

I have a variable which contains a number, I want to pad it with zeros to make it 6 figuers long. ie 1 would become 000001

But Cann't see anything in the help that tells me how to do it.

I am using sqlserver 7

Thanks

Rob

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources