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.)
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:
where upper(myField) = 'FRED'
I've never tried trim before so I don't know if it's supported.
I'll give the UPPER() a shot. TRIM(), I'll play around with and report back.
UPPER() worked like a charm. As far as TRIM() - it's just TRIM(columnName), nothing else.