TRIM bug

Hello,

I just ran into this and narrowed it down to TRIM. Without the TRIM(), 
it works fine.

In MS Access,
SELECT DISTINCT [Name] FROM [Customer Information] WHERE [Name] IS NOT 
NULL AND LEN(TRIM([Name])) > 1 ORDER BY [Name] ASC;
becomes
SELECT DISTINCT "public"."Orders"."Name"  FROM ("public"."Orders" LEFT 
OUTER JOIN "public"."POs" ON ("public"."Orders"."OnlineCode" = 
"public"."POs"."OnlineCode" ) ) WHERE (NOT(("public"."Orders"."Name" IS 
NULL ) ) AND (char_length(ltrim(rtrim("public"."Orders"."Name" )))))> 1 
) ) ORDER BY "public"."Orders"."Name"
As you can see, there is an extra right parenthesis. (Customer 
Information is an Access query onto Orders, in case the name change is 
confusing from my test example.)

Thanks!

James