Steve,
Either of these SQL queries should work.
select * from theTable where left$(theCol,2) =
any("A0","A1","A2","A3","A4","A5","A6,"A7","A8","A9") into SelTab
or
select * from theTable where left$(theCol,1) = "A" and mid$(theCol,2,1) =
any("0","1","2","3","4","5","6,"7","8","9") into SelTab
Simply substitute theTable and theCol with the appropriate table and column
names.
John Hollingsworth
GIS Manager - MediaStar
Clear Channel Communications
[EMAIL PROTECTED]
w) 817-640-4550x209
c) 817-726-6590
-----Original Message-----
From: Morrier, Steve [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 16, 2001 9:08 AM
To: '[EMAIL PROTECTED]'
Subject: MI-L SQL
What is the correct syntax for selecting all rows in a table where the first
letter is A followed by a number?
For example I want to select all the rows where the ID range of a column is
A - A12.
Thanks for your help
_______________________________________________________________________
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, send e-mail to [EMAIL PROTECTED] and
put "unsubscribe MapInfo-L" in the message body.
_______________________________________________________________________
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, send e-mail to [EMAIL PROTECTED] and
put "unsubscribe MapInfo-L" in the message body.
