Table T has two varchar columns A and B. UI allows entering values into column A only. On insert/update of records, I need to take out the value of A, filter out anything other than '0' to '9', '*', '#', '+' 'p', 'w' characters and copy it to column B. Is it possible to write a trigger to achieve this? If yes please give me a sample. (Also, if column B is in another table, is it possible?)
Thanks -Harish -- View this message in context: http://old.nabble.com/Trigger-to-filter-out-characters-tp30861522p30861522.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users