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 Tandetnikitandet...@mvps.org wrote:
On 2/22/2012
The same, escaping double quotes inside the double quotes:
SELECT '' || replace(replace(text_field,'\','\\'),'','\') || ''
On Thu, Feb 23, 2012 at 15:16, Bill McCormick wpmccorm...@gmail.com wrote:
Yes, that should work.
Thanks!!
Dave Watkinson wrote, On 2/22/2012 5:33 PM:
Did you mean
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;
Thanks!!
___
sqlite-users mailing list
sqlite-users@sqlite.org
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
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
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 itandet...@mvps.org wrote:
On 2/22/2012 6:03 PM, Bill McCormick wrote:
What is the easiest way to return a text