On Tue, Aug 10, 2004 at 08:54:45PM -0400, Robert Fitzpatrick wrote: > I have varchar column with both numbers and letters, like 1 thru 10 and > 5A thru 5G, they are unit numbers for apartments. If I have 1 thru 100, > since it is a varchar field, it sorts like 1,10,11... instead of > 1,2,3... > > Is there any way to handle this without having to make a sort order > column?
Try something like this: ORDER BY SUBSTRING(unitnum FROM '[0-9]+')::INTEGER, unitnum -- Michael Fuhr http://www.fuhr.org/~mfuhr/ ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
