Perhaps by doing an UPDATE with:
set booktitle = upper(substr(booktitle,1,1)) || lower(substr(booktitle,2))
Regards,
-Toby
>Hello
>
>A column holds book titles which are all in capital letters ("MY BOOK
>TITLE"), and I'd like to reformat them as "My book title".
>
>Is there a function in SQLite that does this, or should I use some
>external language to do this?
>
>Thank you.
>
>_______________________________________________
>sqlite-users mailing list
>sqlite-users@sqlite.org
>http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
