Simon Slavin-3 wrote: > > > On 8 Nov 2011, at 10:58am, hmas wrote: > >> My application insert into a table a string of numbers (for exemple >> '999998011295918220'. >> if I do (either from command line or from my c++ program) >> select foocol from footable where foocol = '999998011295918220' >> the result set is empty > > I'm trying to figure out whether that string of digits was stored as a > string or a number. Please do > > SELECT foocol,typeof(foocol) FROM footable WHERE foocol LIKE > '999998011295918220' > > and tell us what the results are. > > Simon. > > Thanks for your answer. > foocol contains a string of numbers. > The result of typeof(foocol) is text. > Herve. > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > >
-- View this message in context: http://old.nabble.com/select-...-where--%3D--or--like--tp32802547p32803113.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
