Hi Jim, On Thu, 1 Feb 2007 09:08:44 -0500, you wrote:
>From the CLP (i.e., w/o user-defined functions) is there any way to get >the equivalent of the sybase ltrim, rtrim functions? (ltrim/rtrim trim >spaces from the right/left end of a column value.) As far as I can tell load_extension(X,Y) can be used in the command line program. I usually postprocess output by piping it through awk to solve these kinds of problems. sqlite3 databasefile <sqlscript | awk -f trim.awk >outfile >jim HTH -- ( Kees Nuyt ) c[_] ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
