Re: [sqlite] double_quote(text_field)

2012-02-23 Thread Benoit Mortgat
The same, escaping double quotes inside the double quotes: SELECT '"' || replace(replace(text_field,'\','\\'),'"','\"') || '"' On Thu, Feb 23, 2012 at 15:16, Bill McCormick wrote: > Yes, that should work. > > Thanks!! > Dave Watkinson wrote, On 2/22/2012 5:33 PM: >> >>

Re: [sqlite] double_quote(text_field)

2012-02-23 Thread Bill McCormick
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 wrote: On

Re: [sqlite] double_quote(text_field)

2012-02-22 Thread Dave Watkinson
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 wrote: > On 2/22/2012 6:03 PM, Bill McCormick wrote: > >> What is the easiest way to return a

Re: [sqlite] double_quote(text_field)

2012-02-22 Thread Igor Tandetnik
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

Re: [sqlite] double_quote(text_field)

2012-02-22 Thread Simon Slavin
On 22 Feb 2012, at 11:03pm, 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; Does SELECT