Thanks will try this one. On Tue, Aug 18, 2009 at 7:36 PM, Moritz Lennert<mlenn...@club.worldonline.be> wrote: > On 17/08/09 08:19, maning sambale wrote: >> >> One column of my vector is the name of the town all in uppercase. >> What I want is to convert them, i.e., >> >> SAN DIEGO > San Diego >> >> My grass dbase is sqlite > > Something like this should do the trick (untested): > > UPDATE YourTable set town=substr(town,1,1) || lower(substr(town,2)) > > Moritz >
-- cheers, maning ------------------------------------------------------ "Freedom is still the most radical idea of all" -N.Branden wiki: http://esambale.wikispaces.com/ blog: http://epsg4253.wordpress.com/ ------------------------------------------------------ _______________________________________________ grass-user mailing list grass-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/grass-user