Concatenate in SQLite

I wrote before on using concatenate in OpenOffice / LibreOffice and how this alternatively can be done in R using the paste function. You can do the same in SQLite using a query too. Continue reading “Concatenate in SQLite”


A concatenate function on steroids for OpenOffice calc

In OpenOffice / LibreOffice Calc, you would normally use CONCATENATE to combine strings from different cells, like in the example below: Continue reading “A concatenate function on steroids for OpenOffice calc”