Griggs, Donald wrote... > 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. ;-)
Why do you say this? Will the table grow because of this statement? I have fixed the client data entry to take care of this in the future, but there are a lot of records that I didnot clean previously, so I need to do this, at least once. > > 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. Thanks. > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
