P Kishor <punk.k...@gmail.com> wrote: > UPDATE OpenJobs > SET notes = 'string to add in front\r\n' || notes > WHERE spid = 32;
Note that SQLite doesn't understand C-style escapes. '\r' is a string consisting of two characters, a backslash and a letter r. If you want to insert CRLF pair, you'd need something like this: SET notes = 'string to add in front' || cast(x'0d0a' as text) || notes Or, you can use a parameter in place of the string literal, and bind a string to it in your program. Such a string can contain any characters you want. -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users