In article [EMAIL PROTECTED],
Robert James [EMAIL PROTECTED] wrote:
% I'd like to order so that records where field='2' come first, then '1', then
% '9', then anything but '0', then '0'. Is there anyway to do this in a
% standard order by clause (that is, without writing a new SQL function)?
I have a one varchar field.
I'd like to order so that records where field='2' come first, then '1', then
'9', then anything but '0', then '0'. Is there anyway to do this in a
standard order by clause (that is, without writing a new SQL function)?
On Jul 18, 2007, at 20:12 , Robert James wrote:
I'd like to order so that records where field='2' come first, then
'1', then
'9', then anything but '0', then '0'. Is there anyway to do this in a
standard order by clause (that is, without writing a new SQL
function)?
# create table