SQLite Forum

Help with a query
Thanks Tim, I am aware of that, the table and fields were created sometime ago using SQLiteExpert's ( http://www.sqliteexpert.com/ )field type mapping list.

At that time ( a long time ago, more than 7 years ) my knowledge was less than it is today, I did not concern myself with the finer details of sqlite but now am in the process of using the amalgamation and compiling it in my developer tools.