Not that I know your business logic, but would it not be a lot easier to store your attributes in a field, say column name = ImportantGrade like a number, instead of hiding data into the another field, where you need to 'decrypt' data to access it. By the way, you can download the MapBasic manual from MapInfo.com, you will find Asc() and all the other functions available listed there. Mvh. | Regards
Jakob Lanstorp Software developer Geographical Information & IT COWI A/S Odensevej 95 DK-5260 Odense S Tel +45 63 11 49 00 Direct +45 63 11 48 62 Fax +45 63 11 49 49 Email [EMAIL PROTECTED] http://www.cowi.dk ________________________________ From: Leonardo Diaz [mailto:[EMAIL PROTECTED] Sent: Thu 12/16/2004 19:38 To: [EMAIL PROTECTED] Subject: Re: MI-L UCase function Peter Horsb�ll M�ller wrote: >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 > > Thanks, it did work, Of course ASC is not in the MI manual nor the help. (But I should have remember it from my Apple ][ BASIC programs!) From the MapBasic window: select * from ar_places where asc(mid$(ppptname,2,1))<91 and mid$(ppptname,2,1) not like "" into Selection browse * from Selection Update Query46 Set PPPTFLAG = 9 Browse * From Query46 Thanks again, -- 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: 14587
