Try StringCompare(str1, str2). It's case sensitive, and returns -1 if str1 is less than str2, 0 if they match and +1 if str1 greater than str2.
On Thu, 16 Dec 2004, Leonardo Diaz wrote: > (Sorry about the first post, it seems the list choked at the signed mail) > > I have information (cities names) in a table field that was coded using > "ALL CAPS" for important places, "Mixed Caps" for less important, etc. > Since I am using this information quite often I wanted to code the > importance in a numeric variable. I tried to use following code > > (ucase$(PPPTNAME) like PPPTNAME) and (ppptname not like "") > > but, of course, LIKE does not care about case. > > Then I tried selecting the second char > > mid$(whatever,2,1), > > making it an integer (function VAL ) Wrong, that's not what VAL is for. > > Now I am stuck, any ideas > > --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 14585
