#67 UPPER clause in SQL causes error message

[Anonymous]

When I try to use the clause UPPER in a SQL
statement I get the error message : 'Query execution
failed. Variant is not an array.' When I remove the
UPPER clause from the statement it works fine.

The query worked with UPPER in Flash Filer 2.12.

[Nobody/Anonymous]

The code of the query

[Anonymous]

Logged In: YES
user_id=747819

The error occurs when one of the fields which is being
checked is empty. You can work around it by extending the
query to check if the field is empty. EG:
And (Field <> '')

[Waldo Quiroga]

Logged In: YES
user_id=894801

I check this error and I verify that it happens when the
table has null values for the field I am using the Upper
statement.
If the table dont have any null field the exception dont
happens.