On 30 April 2010 14:59, Adam DeVita <adev...@verifeye.com> wrote: > Is it possible there is a null, tab, newline or other invisible character? > Try > > select timeStamp, 'yyyy' || resourceType || 'xxxxxx' From MyTable where > resourceType like 'PSM' LIMIT 10; >
Following from Adam's suggestion: null chars in your data (the terminators of your C strings perhaps?) reproduce the effect you report: SQLite version 3.6.11 Enter ".help" for instructions sqlite> sqlite> create table tst( t timestamp, resType text ); sqlite> sqlite> insert into tst values( datetime( 'now' ), 'PSM' ); sqlite> sqlite> insert into tst values( datetime( 'now' ), 'PSM'||X'00' ); sqlite> sqlite> select * from tst; 2010-04-30 14:11:07|PSM 2010-04-30 14:11:17|PSM sqlite> sqlite> select * from tst where resType='PSM'; 2010-04-30 14:11:07|PSM sqlite> select * from tst where resType like 'PSM'; 2010-04-30 14:11:07|PSM 2010-04-30 14:11:17|PSM Regards, Simon _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users