Hi Team,
I have a table with, among others, the following fields..
1. PVSent a boolean flag; and
2.  PONo a CLOB.
If I apply the following sql, all is fine..
{sql}
select * from PVPayments
where PVSent = False
order by PVNo
{sql}
I get what I expect.

If I apply the following sql...
{sql}
select * from PVPayments
where Upper(Trim(BOTH ' ' from PONo)) <> 'CANCELLED'
order by PVNo
{sql}
I also get what I expect.

But if I combine them..
{sql}
select * from PVPayments
where PVSent = False and Upper(Trim(BOTH ' ' from PONo)) <> 'CANCELLED'
order by PVNo
{sql}
I get rubbish.

Help!

Regards & TIA,
Ian

All good.  Senior's moment, or two.