RSS

SQL select statement help

Please support our MS Access and FileMaker Pro advertiser: Programming Forums

SQL select statement help

•

Join Date: Apr 2006

Posts: 1

Reputation: silverspring is an unknown quantity at this point

Rep Power: 0

Solved Threads: 0

silverspring silverspring is offline

Offline

Newbie Poster

SQL select statement help

Apr 25th, 2006

Hi,
I have column with alphanumberic fields like:
trader1.dbpt
1234.mcxl
abc243.cexl
234-lab.cxcl
There are following characteristics of this data:
-fifth last place is always decimal
-always four characters after the decimal
What I want:
-only those rows which have ".mcxl" at the end
-rows should NOT have numbers in them
-rows should not have "-" in them
-want to sort according to the length, shortest should come first
Please guide how to accomplish all this on MS Access in SQL statement

thanks for the help,
Silverspring

DaniWeb Home > Forums > Web Development > Databases > MS Access and FileMaker... > SQL select statement help

SQL select statement help

SQL select statement help

SQL select statement help