this seems to work
edit all from ptinfo where L_name between 'smith' and 'taylor'
so does
edit all from ptinfo where L_name between 'a' and 'g'
Marc
--------------------------------------------------
From: "Javier Valencia" <[email protected]>
Sent: Friday, May 14, 2010 11:08 AM
To: "RBASE-L Mailing List" <[email protected]>
Subject: [RBASE-L] - RE: Query for character range
John,
I am not sure if R:Base allows the query the way you have it structured;
however, you can always use:
select * from myTable where LastName >= 'a%' AND LastName < 'G'
Javier,
Javier Valencia, PE
913-829-0888 Office
913-915-3137 Cell
913-649-2904 Fax
[email protected]
-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of John
Croson
Sent: Friday, May 14, 2010 9:36 AM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Query for character range
Second time posting on this subject. Hope someone can help me.
I'm attempting to match on a range of characters in a query;
select from myTable where LastName like '[A-F]%'
This should retrieve everyone that has a last name starting with A
through F, yet it returns no results when there are clearly ones there.
Does R:Base 6.5 not support the use of meta characters for queries?
Thank You!
--
John Croson
[email protected]
[email protected]
<http://www.croson.us> <http://www.twitter.com/pcnorb>
<http://pcnorb.blogspot.com/> <http://www.linkedin.com/in/johncroson>
<http://www.facebook.com/john.croson> <http://croson.smugmug.com/>
