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