On Sat, 31 Dec 2011 13:16:58 -0800, Kai Peters <kpet...@otaksoft.com> wrote:
> >Hi, > >how can I insert a control character like carriage return? > >Something like: > >update fielddefs > set choices = 'Male' || '\r' || 'Female' where id = 2 Line endings can be included in text literals: UPDATE fielddefs SET choices = 'Male' || ' ' || 'Female' WHERE id = 2; There's no need for concatenation here, this would have the same result: UPDATE fielddefs SET choices = 'Male Female' WHERE id = 2; -- Regards, Kees Nuyt _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users