RE: [sqlite] Function question

2007-02-01 Thread Anderson, James H \(IT\)
That's an interesting idea, thanks, Kees. -Original Message- From: Kees Nuyt [mailto:[EMAIL PROTECTED] Sent: Thursday, February 01, 2007 2:57 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Function question Hi Jim, On Thu, 1 Feb 2007 09:08:44 -0500, you wrote: >From the

Re: [sqlite] Function question

2007-02-01 Thread P Kishor
-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 th

Re: [sqlite] Function question

2007-02-01 Thread P Kishor
> 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? (ltri

Re: [sqlite] Function question

2007-02-01 Thread Kees Nuyt
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)

RE: [sqlite] Function question

2007-02-01 Thread Anderson, James H \(IT\)
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

Re: [sqlite] Function question

2007-02-01 Thread Nemanja Corlija
-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

RE: [sqlite] Function question

2007-02-01 Thread Anderson, James H \(IT\)
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 (

[sqlite] Function question

2007-02-01 Thread Anderson, James H \(IT\)
>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.) jim NOTICE: If received in error, please