Hello,
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%'

of course \n doesn't work.

many thanks in advance for your help.

Cheers,
Sylvain
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to