How does the replace function identify a windows CRLF? I've tried
using \n, \r, \p, 0D0A, etc. I just want to remove multiple carriage
returns from a text typed field. Something like: Select replace
(field1, '\n\n','\n') from table; I've just started dabbling with
SQLite. I mainly work with MSSQL at the moment but I'm liking what I
see so far. Also, is there a more comprehensive function list other
than http://www.sqlite.org/lang_corefunc.html ?
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
