> Also, is there a more comprehensive function list other > than http://www.sqlite.org/lang_corefunc.html ?
If you look closely at http://www.sqlite.org/lang.html you'll find these links: http://www.sqlite.org/lang_corefunc.html http://www.sqlite.org/lang_aggfunc.html http://www.sqlite.org/lang_datefunc.html And all these three links combined list all functions that SQLite understands unless you (or you database manager application) register some user-defined functions. Pavel On Thu, Sep 17, 2009 at 2:52 PM, Matt Williamson <mattw1...@gmail.com> wrote: > 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 > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users