ODBiC Discussion Board


re: sorting

by covesy, March 13, 2004 01:37

Create a "sorting field", then add sort oder as required. e.g. [model] D-18, insert D018 in [sort field] [model] D2-09,insert D209 in [sort field] [model] D-21, insert D021 in [sort field] , etc, etc.

Do "ORDER BY" [sort field] and result output is: D018 (D-18), D021 (D-21), D209 (d2-09)


Replies:


Post Your Reply:

Name   
E-mail  optional
Topic  
Message:

HTTP Link: 
Link text: 


Copyright ©1997-2003, Roger Harris. All rights reserved.