On 9/10/08, Josh Millstein <[EMAIL PROTECTED]> wrote: > The trim before I put data in was based on using a programming language and > not the db language. I want to do it all in sql syntax >
What Igor suggested *is* SQL syntax INSERT INTO table (col) VALUES (trim(<string>)) > > > On 9/9/08 12:52 PM, "P Kishor" <[EMAIL PROTECTED]> wrote: > > > On 9/9/08, Josh Millstein <[EMAIL PROTECTED]> wrote: > >> Hello, > >> > >> Is there anyway to perform a trim to everything that is entered into a > table > >> instead of trimming before I put data in? > > > > aren't "perform a trim to everything that is entered into a table" and > > "trimming before I put data in" the same actions? > > > > > >> > >> Thanks, > >> Josh > >> > >> -- > >> > >> > >> _______________________________________________ > >> 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 > -- Puneet Kishor http://punkish.eidesis.org/ Nelson Institute for Environmental Studies http://www.nelson.wisc.edu/ Open Source Geospatial Foundation (OSGeo) http://www.osgeo.org/ _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
