Regarding: I know that trim(vEmail) will do it, but what would be the command to run to trim all of the existing records?
UPDATE LSOpenJobs SET vEmail = TRIM(vEmail); Given the state of the world economy, I hope that LSOpenJobs is an ever-expanding table. ;-) Regarding: Also, how to I trim specific characters? If you don't need to keep such characters at ALL, you can use REPLACE with hex literals to change unwanted, non-whitespace characters to spaces, then TRIM. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
