Query of Query - filtering

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,

^_^

This topic has been closed for replies.

Correct answer Dan_Bracuk

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.

Dan_BracukCorrect answer

Inspiring

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.

Brainiac

Hi, Dan.

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

Much appreciated.

^_^

Brainiac

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

Thanks, Dan!

^_^

Sign up