On Tue, 2005-05-03 at 13:29 -0400, Robert Fitzpatrick wrote: > I have a column that I want to sort by certain values. The values are > Unit, Exterior and Common. I want all the records with Unit first, > Common second and Exterior last in the sort order. These are the only 3 > possible values, is there a way to sort manually like that with the > alphanumeric values? ... ORDER BY length(col); :-) gnari ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
