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.)
I don't know what a "CLP" is, but all the core functions are
documented at <http://www.sqlite.org/lang_expr.html>, and no,
ltrim/rtrim are not in the list, nor is anything that can easily help
cook up ltrim/rtrim functionality afaict. On the other hand, they are
trivial capabilities to add via custom functions and your programming
interface of choice.
--
Puneet Kishor http://punkish.eidesis.org/
Nelson Inst. for Env. Studies, UW-Madison http://www.nelson.wisc.edu/
Open Source Geospatial Foundation http://www.osgeo.org/education/
---------------------------------------------------------------------
collaborate, communicate, compete
=====================================================================
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
