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

[maning sambale]

Thanks will try this one.

On Tue, Aug 18, 2009 at 7:36 PM, Moritz
Lennert<mlennert at 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/
------------------------------------------------------