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
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
