On 3/22/18, 9:22 AM, "sqlite-users on behalf of Ron Watkins" <sqlite-users-boun...@mailinglists.sqlite.org on behalf of rwa...@gmail.com> wrote: > Is there an easy way to "fix" the data already in the table?
The string trim trick David and Ryan suggested would work. To avoid banging on rows already converted, maybe: UPDATE foo SET dttm = trim(dttm,'''') WHERE dttm like '''%'''; Note that's 4 single quotes in the first string, and two sets of three single quotes in the second. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users