Richard Nagle <cms01-odAbcf0Mc9JJm/[EMAIL PROTECTED]> wrote:
Does SQLite support any direct built-in commands, that can
manipulate data?
ie.
suppose the boss wanted a report of cars honda in CA,
but he wants to see the California instead of CA,
so you need to convert all the state fields into full names,
how would this be done...
Add a table with two columns to the database, one with the state
abbreviation and the other with full state name. Then you can do
something like this:
select make, model, fullstate
from cars join states on (cars.state = states.state)
where make='honda'
Alternatively, register a user-defined function using
sqlite3_create_function[16] that would perform the translation, and use
the function in the query.
Igor Tandetnik
