John, Steve,
What about just using the SQL select box and having:
Select *
from YourTab
where YourCol like "A%"
HTH,
Chris Perry
Corporate Systems CoOrdinator
Parks Victoria
Level 13 / 535 Bourke Street
Melbourne Vic 3000
Australia
Ph: 61 3 8627 4600
Fax: 61 3 9619 0700
-----Original Message-----
From: Hollingsworth, John C. [mailto:[EMAIL PROTECTED]]
Sent: Saturday, 17 March 2001 1:59
To: 'Morrier, Steve'; '[EMAIL PROTECTED]'
Subject: RE: MI-L SQL
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.
**********************************************************************
This message and any files transmitted with it are intended only for
the addressee. This message may contain confidential or privileged
information. If you are not the addressee of this message you must not
read, copy, distribute this information or take an action in reliance on it.
If you have received this message in error you are requested to
immediately contact the sender or Parks Victoria at
[EMAIL PROTECTED] and delete the original and any copies
of this message and any files transmitted with it. The views expressed
in this message are those of the individual sender, except where the
sender has the authority and specifically states them to be the views
of Parks Victoria. Parks Victoria accepts no liability for any damage
caused in the transmission, receipt or opening of this message and any
files transmitted with it.
**********************************************************************
~~~~~~~~~~~~~~~~~~~~~~~~ List Sponsor ~~~~~~~~~~~~~~~~~~~~~~~~~
Navglobe.com is the journal of global navigation and wireless communication.
It covers issues, products, and services without emphasizing any one vendor.
Interested? Visit http://www.navglobe.com and click "Subscribe." This also
makes you eligible to win DeLorme's Earthmate GPS receiver and Solus Pro 3.0.
Using Solus, you can download and view vector and raster street-level maps on
a PalmOS handheld.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
_______________________________________________________________________
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.
