In the last episode (Mar 23), Jacque Scott said: > I have something like A001C, B689, B1001 etc...
Aah. This question pops up about once a year, usually under the subject of "Natural Sorting". There's no builtin function for doing this, but one solution would be to write a UDF that finds runs of numeric characters, and zero-pads them out to, say, 5 digits. Then using ORDER BY padnumbers(myfield), your three sample values will look like A00001C B00689 B01001 , and mysql will sort them right. -- Dan Nelson [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]