System.Data.SQLite

I have a table called products with three columns a, b and c

I am trying to add the data from both the a and b columns into c, also a little bit of added text

I have tried many ways but not with any luck..

Basically this is what I am looking for...

Update products

Set c = a + “ some text “ + b;

Just adding one Colum of data works fine...

Update products

Set c = a;

I have searched high and low but not found any solution, any help would be gratefully received as I have run out of idea’s,

Thanks in advance.

Thanks very much sunshine, working perfectly.

 I have spent two days trying to work that one out.

That is correct. See section 4.0 of http://www.sqlite.org/datatypes.html. More generally, see http://www.sqlite.org/lang_expr.html.

I'm ashamed to say that I looked through that section several times over the last 48 hours and did NOT notice it.