subject:"Order by on Alphnumeric"

Order by on Alphnumeric

2002-02-27 Thread Prospect'In

sql,query Good Day, I have a varchar field which contains alphanumeric data. I want to be able to order this field by only the numeric values in the field. help!! Rick - Before posting, please check:

RE: Order by on Alphnumeric

2002-02-27 Thread Daniel Rosher

select * from table where strcol REGEXP ^[[:digit:]]+$ order by strcol Regards Dan -Original Message- From: Prospect'In [mailto:[EMAIL PROTECTED]] Sent: Thursday, 28 February 2002 11:31 a.m. To: [EMAIL PROTECTED] Subject: Order by on Alphnumeric sql,query Good Day