Hello,
I am looking for a way to sort by numbers without having to pad the database field.
So, if I have a field titled "price" and I specify to sort by that field I want to be sure that $9.99 comes before $19.99
I understand that I can enter these numbers into the database as 009.99 & 019.99 and they will sort properly, but since I am importing large numbers of links this is not feesible.
Any help would be appriciated
Thanks
George
I am looking for a way to sort by numbers without having to pad the database field.
So, if I have a field titled "price" and I specify to sort by that field I want to be sure that $9.99 comes before $19.99
I understand that I can enter these numbers into the database as 009.99 & 019.99 and they will sort properly, but since I am importing large numbers of links this is not feesible.
Any help would be appriciated
Thanks
George