3 Replies Latest reply on Feb 13, 2013 12:52 PM by WolfShade

    Query of Query - filtering

    WolfShade Level 4

      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,

       

      ^_^