On 24 Oct 2013, at 3:12pm, dd <durga.d...@gmail.com> wrote: > SELECT typeof(emp_id), typeof(emp_mngr_id) FROM employee; > > typeof(emp_id) | typeof(emp_mngr_id) > > text text > text text > .... ... > text text
Then they're stored as text. And will be sorted as text. Which is probably not what you want. The following four types are defined for SQLite: INTEGER REAL TEXT BLOB. Define each column as one of those, not made-up things like STRING. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
