You are right, you shouldn't use val() as it will return 0. Asc() is the function you are looking for, and all you now need to know is that A-Z equal 65-90 and a-z equal 97-122
HTH, Peter Horsb�ll M�ller GIS Developer Geographical Information & IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk/gis -----Original Message----- From: Leonardo Diaz [mailto:[EMAIL PROTECTED] Sent: Thursday, December 16, 2004 6:28 PM To: MapInfo-L Subject: MI-L UCase function (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 --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 14584
