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