On 22 Feb 2012, at 11:03pm, Bill McCormick <wpmccorm...@gmail.com> wrote:
> What is the easiest way to return a text field with double (") quotes? > > SELECT quote(text_field) FROM table; is close, but I'd rather have a SELECT > double_quote(text_field) FROM table; Does SELECT quote(quote(text_field)) FROM table; work ? Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users