hi again,
Now I need to sort a field of varchar type. But the filed values are like... b1,b2,b3,b4,b5,b6,b7,b8,b9,b10,b11,b12.... meaning thereby, an integer prefixed by some character. Is there any straight way to frame the query? thanx in advance for your time, regards, -vishi --------------------------------------------------------------------- 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
