On 22 Feb 2012, at 11:03pm, Bill McCormick <[email protected]> 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
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
