On May 19, 2008, at 9:03 PM, Skip Evans wrote: > Hey D. Richard & all, > > Casting them as int's also did not work. Here's > the schema: > > CREATE TABLE bsp_options > ( > optionsID INTEGER NOT NULL PRIMARY KEY, > modelID INT(11) NOT NULL, > startyear VARCHAR(4) NOT NULL DEFAULT '0', > endyear VARCHAR(4) NOT NULL DEFAULT '0', > options TEXT NOT NULL, > productcodesize VARCHAR(10), > productdesc VARCHAR(200), > pattern VARCHAR(10) > );
What does this show: SELECT DISTINCT typeof(startyear) FROM bsp_options; SELECT DISTINCT typeof(endyear) FROM bsp_options; D. Richard Hipp [EMAIL PROTECTED] _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users