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 [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
