You must use || (doble pipe) to concatenate strings or what ever. Note that || don't concatenate nulls
'CHE' || null is null sorry about my poor english Joanne Pham escribió: > Hi All, > I had the table, appMapTable as defined below: > appId, appName, appType > 1, appname, 2 > 2, appname, 3 > .... > appName always has string as appname and now I want to concatenate the > appName with appId > so the result will be: > 1,appname1,2 > 2, appname2,3 > ..... > I ran the following sql statement : > update appMapTable set appName = appName + appId > but the result is not what I want. Would you help? > Thanks, > JP > > > > ____________________________________________________________________________________ > Be a better friend, newshound, and > know-it-all with Yahoo! Mobile. Try it now. > http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ > _______________________________________________ > 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