Hi,
I'm running 3.3.15. No problem at all. Maybe your version does not have this
implemented yet...
best regards,
Radzi.
----- Original Message -----
From: "Stef Mientki" <[EMAIL PROTECTED]>
To: <sqlite-users@sqlite.org>
Sent: Monday, April 16, 2007 10:14 PM
Subject: [sqlite] trim available ??
hello,
As I read here
http://www.sqlite.org/lang_expr.html
there are trim functions availabel as part of an expression.
But when I try to execute the next statement:
SELECT App FROM PO WHERE LOWER(App_Type) = TRIM(LOWER('{ Afzuigapparaat }
'))
I get the following error
/******** ERROR **********
Error executing SQL
"SELECT App FROM PO WHERE LOWER(App_Type) = TRIM(LOWER('{ Afzuigapparaat }
'))
"
:: no such function: TRIM
**************************/
What am I doing wrong ?
thanks,
Stef Mientki
Kamer van Koophandel - handelsregister 41055629 / Netherlands Chamber of
Commerce - trade register 41055629
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------