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/>
