>Could you please show me how to write the condition (to filter out >characters)?
Use the strfilter function found in extension-functions.c downloadable from http://www.sqlite.org/contrib/ Once built and loaded, you can use a trigger similar to create trigger if not exists trFilterAB after insert on mytable begin update mytable set columnB = strfilter(new.columnA, '0123456789*#+pw') where rowid = new.rowid; end; @venkat, I guess the OP needs to filter out characters not in the prescribed set, not sort out if the data is a 1-character string in this set. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users