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 ?

Reply to this topic