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 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.

Ha ha ha... very good.  I get it now... :-)  That is comedy, right there.  I 
don't care what anybody says...  Heck, it's so funny that I am going to 
laugh in Spanish, Ja ja ja ja ja...

> The sql below should not increase the size of your database.
>  UPDATE LSOpenJobs
>    SET vEmail = TRIM(vEmail);

thanks.

>
> Wishing you peace and prosperity,

thanks and likewise.

josé 

_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to