On Tue, Sep 16, 2008 at 3:49 PM, Igor Tandetnik <[EMAIL PROTECTED]> wrote: > But if you insist on doing it in SQL, this should work: > > sqlite3 foobar.db "select replace(id,'_',cast(x'09' as text)) from bar;"
That worked: $ sqlite3 foobar.db 'select replace(id,"_",cast(x"09" as text)) from bar;' Although, using cast was non-obvious to me from reading the docs: http://www.sqlite.org/lang_expr.html Here's another version using bash syntax to insert the tab character: $ sqlite3 foobar.db 'select replace(id,"_","'$'\t''") from bar;' Thanks, Igor. Regards, - Robert _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
