Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Using the Field Calculator in ArcGIS 10.1, I am able convert the first letter in a value from lower case to upper case. How do you convert the entire value to upper case, though? I can't seem to locate a VBScript for it.

For example, I want to convert small to SMALL.

share|improve this question
Use Python parser. – Tomek May 31 '13 at 13:57
up vote 6 down vote accepted

You can use UCase

UCase( [fieldName] )
share|improve this answer

Another alternative using Python would be:


as described in the online help Calculate Field examples.

share|improve this answer
Why do they need to change the scripting where there is more room for errors. Why not just keep VBScripting for the latest Arc versions? – Zoran May 31 '13 at 15:26
+1 it would be best for everyone to wean themselves off vbscript and move onto python asap. – Cindy Williams-Jayakumar May 31 '13 at 15:49
There is no mention of vbscript being deprecated in Desktop (yet), but if you read into the long term future of vbscript (on Desktop) based upon the ArcGIS Server deprecation plan, can it be too far off? ArcGIS 10.1 for Server no longer supports VBScript or JScript expressions on Linux. [...] Python scripting will be added as a replacement for these scripting languages and ArcGIS Desktop will support authoring Python scripts in areas where VBScript and JScript are presently used. – RyanDalton May 31 '13 at 16:39

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.