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
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
> 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
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
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
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
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
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
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
9 matches
Mail list logo