> 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. ===================== Jose, I beg your pardon. My comment ending with ;-) was simply a poor joke, presuming that LSopenJobs was a list of available jobs -- something I hoped would increase during a time of large unemployment in the world. The sql below should not increase the size of your database. UPDATE LSOpenJobs SET vEmail = TRIM(vEmail); Wishing you peace and prosperity, Donald _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users