I am trying to append text to a field within my database - sothat if a user has stored 'search, tools' into the Tags column of tblEntry, they can add more tags later like:
update tblEntry set Tags = Tags + ' new text' where RowID = 13 But whenever I try to do this I end up with 0 in the column. I've done searches and found discussions on concat(..) or append(..) but when I try to use these sqlite doesn't recognize them. How do I go about adding a value to the end of an existing value? Do I need to retrieve it and append it in my Java code as opposed to in the sql statement? Thanks! _________________________________________________________________ Windows Liveā¢: Keep your life in sync. http://windowslive.com/explore?ocid=TXT_TAGLM_WL_allup_1a_explore_042009 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users