(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
-- Leonardo D�az
Tel: 56 (2) 321 8323 / 51 (1) 241 5793 Cel: 56 (9) 419 7173 / 51 (1) 9756 0112
GnuPG key: DEA68BCC
smime.p7s
Description: S/MIME Cryptographic Signature
