Re: [GRASS-user] change some labels to upper/lower case in vector attributes

2009-08-18 Thread Moritz Lennert
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) ||

Re: [GRASS-user] change some labels to upper/lower case in vector attributes

2009-08-18 Thread maning sambale
Thanks will try this one. On Tue, Aug 18, 2009 at 7:36 PM, Moritz Lennertmlenn...@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

[GRASS-user] change some labels to upper/lower case in vector attributes

2009-08-17 Thread maning sambale
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 -- cheers, maning -- Freedom is still the most radical idea of all -N.Branden wiki: