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

Reply via email to