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 something like >> >> SELECT '"'||text_field||'"' FROM table; >> >> so that your column's data is quoted? -- Benoit Mortgat _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users