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 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<http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users>
>
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
