"Sylvain Pointeau" <[email protected]> wrote in message news:[email protected] > 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 [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
