On 9/9/08 11:46 AM, "Igor Tandetnik" <[EMAIL PROTECTED]> wrote:
> Josh Millstein <[EMAIL PROTECTED]> > wrote: >> Is there anyway to perform a trim to everything that is entered into >> a table instead of trimming before I put data in? > > I'm not sure I understand the question. Are you perhaps thinking of > > update mytable set myfield=trim(myfield); > > Igor Tandetnik > Yeah, but can you do that automatically on each insert into the db. Trim the whitespace, that is?> > > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- [EMAIL PROTECTED] 785-832-9154 _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
