On 2014/10/14 13:09, Clemens Ladisch wrote:
Paul Sanderson wrote:
SELECT CASE WHEN previd = 0 THEN '--------------' || char(10) END, *
FROM (SELECT ...);
This solution from Clemens will work perfectly, and depending on the kind of OS you use and output method it might even work to add
something like '-----\n' or '----\r\n' as the Inserted item if char(10) causes headaches. On output produced for Windows systems
that should also be char(13) || char(10).
Have a great day!
Ryan
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
