Another interesting thing: Using an IMPLICIT cast with "word+0" does NOT affect the preceeding "word" as does the explicit CAST.
(tested with 3.6.0 pre-compiled win binary CLI utility) Using implicit "+0": sqlite> SELECT word, word+0, word FROM junk where rowid=8; applied|0|applied Using explicit CAST, the output is different from earlier releases: sqlite> SELECT word, cast(word AS INTEGER), word FROM junk where rowid=8; 0|0|applied Or even combine them as: sqlite> SELECT word, word+0, word FROM junk where rowid=8 ...> UNION ...> SELECT word, cast(word AS INTEGER), word FROM junk where rowid=8; 0|0|applied applied|0|applied And, to repeat from my previous email, the following also works as expected: sqlite> SELECT cast(word as TEXT), cast(word AS INTEGER), word FROM junk where rowid=8; applied|0|applied _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
