John, At least I don't know this feature in R:base. But as always there are more roads leading to Rome (as we say in Holland) Try to make use of an temp table, in which you can store the allowed characters
For instance: Suppose your temp table contains the allowed starting character Then you can select these with following statement Select all from <Tablename> where (sget(columnname,1,1)) in (select <columname_temp_table> from <temp_table>) In this way you are able to select on every part of the column. In this example it is the first character and only 1 character. But you also can specify another part of the column. The only restriction is that you cannot make use of the like function, but in essence you are making use of it by only taking a part of the original column. The nice part of this solution it's very flexible and you are able to specify your criteria as much as you like. The only thing I am not sure of is the performance of the query in a huge table. Keep in mind that indexes in the temp table are possible. Succes. Tony IJntema -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of John Croson Sent: vrijdag 14 mei 2010 16:36 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/>
