4 Dec 2009 at 01:41 #1 PMWD PMWD Associate Joined 8 Aug 2008 Posts 302 Is it possible to do a query so it ORDERS BY one column if it has a value and another if not? Basically I want to pull out a list in the order of column A or B. Now column A will always have a value, B not so. Any thoughts? Cheers
Is it possible to do a query so it ORDERS BY one column if it has a value and another if not? Basically I want to pull out a list in the order of column A or B. Now column A will always have a value, B not so. Any thoughts? Cheers
4 Dec 2009 at 12:52 #5 PMWD PMWD Associate OP Joined 8 Aug 2008 Posts 302 Cheers for the input guys, Haircut your solution was bang on.
4 Dec 2009 at 23:17 #7 PMWD PMWD Associate OP Joined 8 Aug 2008 Posts 302 Hi Moredhel, is that true for updates as well?
