OT- SQL PADDING QUESTION

[Eric Creese]

I forget how to do this, it has been some time. I got values that need to be at least 7 characters long. So if the value is 552, I need to pad it out to look like this 0000552 in my return set. Can anyone out there refresh my memory please.

---

[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

---