table help

Discussion created by caleb_87 on Sep 27, 2011
Latest reply on Sep 27, 2011 by caleb_87
I have a shapefile for major rivers in Iowa and when I went to label them I experienced a problem. This shapefile was pulled from the Iowa Natural Resources GIS website and the river names were in all caps. I was able to use field calculator to convert all the labels into lower case, however, I am trying to see if there is a way to capitalize only the first letter. There are 1781 records so I do not really want to manually fix all of them. Also, some of the rivers have two word names. Basically I am wondering if there is an expression I can write to capitalize the first letter of every word in my river name field?