Your case statement syntax is completely off. Also, the concatenation operator in sqlite is ||, not +.
Try this: insert into Customer(id) select case when b.id = id then b.id||'A' else b.id end from customerb b Balaji Ramanathan _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
