Forums
 This topic is locked 
             Need SQL help !!
 Posted 20 Mar 2001  14:32:50 
  1 
     has   voted 
  20 Mar 2001  14:32:50 Michael Guntenaar posted: 
 Hi there I gotta problem with an query I want to extend in my dbase I have an sort field (in this way I can manipulate whats the sort ) my first fields are like 001, 002,003 etc etc but after that an default value is 100 I want the first (other than 100) to sort by number but after that (everything with the value 100 I want to sort on ID number) is this possible ?