OK, thanks. -----Original Message----- From: Nemanja Corlija [mailto:[EMAIL PROTECTED] Sent: Thursday, February 01, 2007 2:33 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Function question
On 2/1/07, Anderson, James H (IT) <[EMAIL PROTECTED]> wrote: > Does the fact that I have received no reply mean that there's no way to > get this functionality within the CLP? > > -----Original Message----- > From: Anderson, James H (IT) > Sent: Thursday, February 01, 2007 9:09 AM > To: sqlite-users@sqlite.org > Subject: [sqlite] Function question > > 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.) > SQLite doesn't have any trim functions by default. Here's a list of available functions: http://www.sqlite.org/lang_expr.html#corefunctions If you decide to write one your self, you can compile it as a loadable extension and load it at runtime from SQL using load_extension() function. -- Nemanja Corlija <[EMAIL PROTECTED]> ------------------------------------------------------------------------ ----- To unsubscribe, send email to [EMAIL PROTECTED] ------------------------------------------------------------------------ ----- -------------------------------------------------------- NOTICE: If received in error, please destroy and notify sender. Sender does not intend to waive confidentiality or privilege. Use of this email is prohibited when received in error. ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
