Thanks will try this one.
On Tue, Aug 18, 2009 at 7:36 PM, Moritz
Lennert 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