Brett Parker wrote:

In case one wasn't aware, all fields in sqlite are text. Nothing else. It doesn't do type checking.

It is not really so simple. Please have a look at http://www.sqlite.org/datatype3.html For reordering the columns of a table one could resort to a temporary table. create temporary table temptab as select column4, column3, column2, column1 from sometable; select * from temptab; I think that this is more flexible than reordering the columns of the main table. Remember that "temptab" is temporary and lasts only the current session, something I consider a feature. Govind Chandra