Guest Posted December 7, 2003 Share Posted December 7, 2003 I have a problem where products that have a numeric suffix are listed in numeric order. Thant's what I am trying to achieve so what's the problem? Well, once we get to 10, the '10' product is sorted higher than a '5'... In the following example, the product and length would be stored as the product name field since each size then has unique attributes (colour, accessories) that prevent having one product with length as an attribute. Output Product - 10m long Product - 12m long Product - 5m long Product - 8m long Desired Product - 5m long Product - 8m long Product - 10m long Product - 12m long Does anyone know how I can read the product name and take into account the actual numeric value and order it correctly? TIA Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.