Re: FN-FORUM: Storing the leading 0 of product codes in MySQL

date posted 11th October 2006 12:06



D D Glendinning wrote:
>
> Paul.
>
> Thanks for your thoughts... It is being stored as two fields because I
> need to be able to order by the number when the products are listed..
> Thats also the reson why I can't store the number as text, or else it
> won't oder numerically.
>
> Any more ideas?
>
> D
>
If you order by a text field it will order by character, so if the first
letter of your code is a 0 it will be ordered before the ones that begin
with 1 and so on.