SQL select statement help - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Other Forums

MS Access

SQL select statement help

Author

Topic

silverspring
Starting Member

1 Post

Posted - 2006-04-25 : 15:31:37

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

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2006-04-26 : 01:01:55

Learn SQL
http://www.sql-tutorial.net/
http://www.firstsql.com/tutor.htm
http://www.w3schools.com/sql/default.asp

Madhivanan

Failing to plan is Planning to fail

jsmith8858
Dr. Cross Join

7423 Posts

Posted - 2006-04-26 : 09:27:51

Sounds like an interview question.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources