2009/12/15 D. Richard Hipp <d...@hwaci.com>: > >> > > Because string '2' is not the same thing as integer 2. > > sqlite3> select 2='2'; > 0 > sqlite3> >
Why sqlite> select cast( 2 as integer ) = '2'; 1 > > D. Richard Hipp > d...@hwaci.com > Simon _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users