"Sylvain Pointeau" <sylvain.point...@gmail.com> wrote in message news:af5c8a920904030325w631f8dfcu90f5f80266f57...@mail.gmail.com > I have some line feed in one field in my table > and I would like to replace this line feed by a space. > > How do I specify the character "line feed" (\n) > in my query? > > ex: select * from mytable where myfield like '%\n%'
Just literally enter a line feed: select * from mytable where myfield like '% %' Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users