Hi,

A friend has migrated from 1.5 and the following SQL sentence report
the "expression evaluation not supported" error. He said that In
v1.5 the same SQL worked fine. Someone have any idea on how to solve this?

select tipotributo, produto, sum(SUBSTRING(quantidade from 1 for 2)) ,
sum(valorunitario) from itensvenda
where tipotributo = '1'
group by tipotributo, produto
order by sum(SUBSTRING(quantidade from 1 for 2)) desc


Thanks,

Anderson