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

[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) || lower(substr(town,2))

Moritz