The difference is that James' version takes advantage of the fact that (ISALPHA(string)) only tests the first character of the string, and thus the (SGET( )) in the first part of the expression from my example is not required. Also, he's putting the 1 on the left side of the equations; it works either way.
Note that (ISDIGIT( )) also only tests the first character of the string, but in your query you still have to extract the last character of the policy number using (SGET( )) to test. Emmitt Dove Manager, Converting Applications Development Evergreen Packaging, Inc. [email protected] (203) 214-5683 m (203) 643-8022 o (203) 643-8086 f [email protected] -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of John Croson Sent: Friday, May 14, 2010 15:40 To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Query for character range I think both work. Neither query barked at me.
