On Tue 18 May 02004 at 04:53:52PM -0400, [EMAIL PROTECTED] wrote: > > Jacob, > > Don't worry about storing the leading the zeroes. Just left pad the > subscriber column to be 4 digits on output and you should be golden. MySQL > has a function just to generate left-padded numbers: > > LPAD(subscriber,4,'0') > > Yours, > Shawn Green > Database Administrator > Unimin Corporation - Spruce Pine
I just came across ZEROFILL in the manual. When would I want to use LPAD rather than ZEROFILL? -- Jacob Elder -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]