it is really perfect,thank you so much On Fri, Apr 3, 2009 at 2:55 PM, Simon Davies < simon.james.dav...@googlemail.com> wrote:
> 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 > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users