:) Thanks.
On Thu, Nov 22, 2012 at 12:28 PM, Simon Davies <simon.james.dav...@gmail.com > wrote: > On 22 November 2012 11:20, Staffan Tylen <staffan.ty...@gmail.com> wrote: > > I run this (sql.txt): > > > > create table table1 (age_band); > > insert into table1 values(31); > > UPDATE table1 SET age_band = (case when age_band <= 10 then ' 0 - 10' > > when age_band BETWEEN 11 AND 20 then ' 11 - 20' when age_band BETWEEN > > 21 AND 30 then ' 21 - 30' when age_band BETWEEN 31 AND 40 then ' 31 > > - 40' when age_band BETWEEN 41 AND 50 then ' 41 - 50' when age_band > > BETWEEN 51 AND 60 then ' 51 - 60' when age_band BETWEEN 61 AND 70 > > then ' 61 - 70' when age_band BETWEEN 71 AND 80 then ' 71 - 80' when > > age_band BETWEEN 81 AND 90 then ' 81 - 90' when age_band BETWEEN 91 > > AND 100 then ' 91 - 100' when age_band > 100 then ' over 100' else > > age_band end); > > select * from table1; > > > > and get this: > > > > SQLite version 3.7.15 2012-11-09 21:40:02 > > Enter ".help" for instructions > > Enter SQL statements terminated with a ";" > > sqlite> .read sql.txt > > age_band > > ---------- > > 31 > > - 40 > > > > To sure what might be causing the line break, it only seems to happen for > > this age band. > > The literal selected contains the line break > > sqlite> select '31 > ...> - 40'; > 31 > - 40 > > sqlite> select '31 - 40'; > 31 - 40 > sqlite> > > > > Staffan > > > > > Regards, > Simon > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users