1 Reply Latest reply on Sep 13, 2006 7:40 PM by EmmanuelRuiz

    query returns too many results

      I have this query that returns 118,900 records when I try to add

      or oth_tchname_ssn like '%123456789%'

      at the end of the query.

      When I remove the or oth_tchname_ssn like '%123456789%' it returns 32 records which seems about right.

      Any ideas as to where my cfquery statement is wrong?