Query of Query - filtering

[WolfShade]

Hello, everyone.

I need to do a QoQ and get a COUNT() of the records that fit a certain criteria, using TRIM and UPPER to make sure the match is solid.

In Oracle, it would be SELECT COUNT(*) as TOTALS FROM tableName WHERE UPPER(TRIM(both ' ' FROM columnName)) = 'THISWORD'

But Oracle conventions don't work in QoQ.  What would be the CF QoQ equivalent?  (I'm sure it's something simple and I'm just too tired to see it.)

Thanks,

^_^

[Dan_Bracuk · Accepted solution]

Are you sure that will work in Oracle?  Looks like an incomplete subquery to me.

In any event, "upper" is supported by QofQ.  I know you can do this:

select count(*)

from myQuery

where upper(myField) = 'FRED'

I've never tried trim before so I don't know if it's supported.

[WolfShade]

Hi, Dan.

I'll give the UPPER() a shot.  TRIM(), I'll play around with and report back.

Much appreciated.

^_^

[WolfShade]

UPPER() worked like a charm.  As far as TRIM() - it's just TRIM(columnName), nothing else.

Thanks, Dan!

^_^