Re: MI-L UCase function

[Leonardo Diaz]

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