RSS

Re: SQL select statement help

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

SQL select statement help

•

Join Date: Jul 2005

Location: Dallas, TX

Posts: 482

Reputation: campkev is an unknown quantity at this point

Rep Power: 4

Solved Threads: 19

campkev

Offline

Posting Pro in Training

Re: SQL select statement help

Apr 26th, 2006

try this

Help with Code Tags

(Toggle Plain Text)

select * from tableName
where columnName like '%.mcxl' 
and columnName not like'%0%'
and columnName not like'%1%'
and columnName not like'%2%'
and columnName not like'%3%'
and columnName not like'%4%'
and columnName not like'%5%'
and columnName not like'%6%'
and columnName not like'%7%'
and columnName not like'%8%'
and columnName not like'%9%'
and columnName not like'%-%'
order by len(columnName) asc

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

Re: SQL select statement help

SQL select statement help

Re: SQL select statement help