2009/4/3 Sylvain Pointeau <sylvain.point...@gmail.com>: > re-hi, > but how do we do if we are on unix and there is some CR on those field? > I cannot insert CR in my statement (only line feed) > > do you have any suggestion? > > Cheers, > Sylvain >
Something like this: SQLite version 3.4.2 Enter ".help" for instructions sqlite> sqlite> create table tst( id integer primary key, data text ); sqlite> sqlite> insert into tst( data ) values( '123 ...> 456' ); sqlite> sqlite> insert into tst( data ) values( 'abc' ); sqlite> sqlite> select * from tst where data like '%'||X'0A'||'%'; 1|123 456 sqlite> select * from tst where data not like '%'||X'0A'||'%'; 2|abc sqlite> Rgds, Simon _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
