On 9/26/05, Richard Nagle <[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... >
There's no built-in function for this cases, you need something like replace(), see http://sqlite.org/lang_expr.html for the built-in functions. You need the aggregate functions. I use SQLite with PHP, so it's easy to create the aggregate functions. > Fields are as follows: > > recid > qty > make > model > year > engine > color > state > price > > > Thanks - > Richard > Regards, -- Firman Wandayandi Never Dreamt Before (http://php.hm/~firman/)
