>From my limited experience. I believe your gonna have to split that one field of alpha and numeric into two fields one for the alpha info and one for the numeric info. Then you can sort the information the way you want.
Mike ----- Original Message ----- From: "Luc Foisy" <[EMAIL PROTECTED]> To: "MYSQL-List (E-mail)" <[EMAIL PROTECTED]> Sent: Tuesday, April 09, 2002 9:55 AM Subject: ORDER BY > > If we have char data field > mixed alpha + numeric data is entered, alpha data is entered, and numeric > data is entered > when we sort this, we would like the numeric data sorted numerically instead > of alphabetically ( while the rest of course sorts alphabetically ) > do I have some kind of option here? > > Luc Foisy > sql,query > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.342 / Virus Database: 189 - Release Date: 3/14/02 --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
