Re: [sqlite] trim'ming a column

2009-12-24 Thread jose isaias cabrera
P Kishor wrote... > On Wed, Dec 23, 2009 at 4:08 PM, jose isaias cabrera wrote: >> >> Greetings and salutations. >> >> I would like to trim a column from all white spaces. I know how to do it >> programmatically, but I would like to do it right to the DB. Is this a >> possibility? >> >> Image thi

Re: [sqlite] trim'ming a column

2009-12-23 Thread jose isaias cabrera
Griggs, Donald wrote... >> 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 ta

Re: [sqlite] trim'ming a column

2009-12-23 Thread Griggs, Donald
> 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 t

Re: [sqlite] trim'ming a column

2009-12-23 Thread jose isaias cabrera
Igor Tandetnik wrote... > jose isaias cabrera > wrote: >> I would like to trim a column from all white spaces. I know how to >> do it programmatically, but I would like to do it right to the DB. Is >> this a possibility? > > update mytable set mycolumn=trim(mycolumn); > >> Also, how to I trim s

Re: [sqlite] trim'ming a column

2009-12-23 Thread jose isaias cabrera
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

Re: [sqlite] trim'ming a column

2009-12-23 Thread Igor Tandetnik
jose isaias cabrera wrote: > I would like to trim a column from all white spaces. I know how to > do it programmatically, but I would like to do it right to the DB. Is > this a possibility? update mytable set mycolumn=trim(mycolumn); > Also, how to I trim specific characters? Say tab, or char

Re: [sqlite] trim'ming a column

2009-12-23 Thread Griggs, Donald
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

Re: [sqlite] trim'ming a column

2009-12-23 Thread P Kishor
On Wed, Dec 23, 2009 at 4:08 PM, jose isaias cabrera wrote: > > Greetings and salutations. > > I would like to trim a column from all white spaces.  I know how to do it > programmatically, but I would like to do it right to the DB. Is this a > possibility? > > Image this statement: > > CREATE TABL

[sqlite] trim'ming a column

2009-12-23 Thread jose isaias cabrera
Greetings and salutations. I would like to trim a column from all white spaces. I know how to do it programmatically, but I would like to do it right to the DB. Is this a possibility? Image this statement: CREATE TABLE LSOpenJobs ( id integer primary key, ProjID integer, subProjID, p