The same, escaping double quotes inside the double quotes: SELECT '"' || replace(replace(text_field,'\','\\'),'"','\"') || '"'
On Thu, Feb 23, 2012 at 15:16, Bill McCormick <[email protected]> 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 [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
