>Hey there,
>
>how would I keep a leading zero? If I fill an int(5) with 03025 it'll
>truncate? (or is that just for behind the comma?) the 0 off. Since I wanna
>use this as primary key and it is to indicate or article numbers, which
>are always 5 numbers, I'd like to keep the 0 in although it's
>insignificant.
Perhaps INT(5) ZEROFILL would do what you want. Either that, or store
the number as a string. Normally strings sort differently than numbers,
but in your case, since you always have the leading zeros, they would
sort in the same order.
A string wouldn't be as efficient, though.
--
Paul DuBois, paul@stripped
Northern League Chronicles: http://www.snake.net/nl/
