Yes, that should work.
Thanks!!
Dave Watkinson wrote, On 2/22/2012 5:33 PM:
Did you mean something like
SELECT '"'||text_field||'"' FROM table;
so that your column's data is quoted?
~~~
Dave Watkinson
On Wed, Feb 22, 2012 at 6:26 PM, Igor Tandetnik<[email protected]> wrote:
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
[email protected]
http://sqlite.org:8080/cgi-**bin/mailman/listinfo/sqlite-**users<http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users>
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
