On 2/22/2012 6:03 PM, Bill McCormick 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;

I'm not sure I understand the nature of the problem. What's wrong with simply

SELECT text_field FROM myTtable;

? There's nothing special about text fields that happen to contain a double quote character.
--
Igor Tandetnik

_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to