here is the link.
http://www.databasejournal.com/scripts/article.php/3385491
-----Original Message-----
From: Cornillon, Matthieu (Consultant) [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 15, 2004 10:54 AM
To: CF-Talk
Subject: RE: OT- SQL PADDING QUESTION
SELECT MyNumber, TO_CHAR(MyNumber,'0000000')
FROM NUMBERS
returns:
1, 0000001
552,0000552
1234567,1234567
HTH,
Matthieu
-----Original Message-----
From: Eric Creese [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 15, 2004 11:33 AM
To: CF-Talk
Subject: OT- SQL PADDING QUESTION
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]
