4 Replies Latest reply on Nov 9, 2006 2:49 PM by MikerRoo

    CFQuery Structure issue

    cluksha Level 1
      Can anyone tell me how I can strip the extraneous characters from a field (during SQL execution) and compare it to a stripped form field?

      For example I would hope this would work in some way - but it don't :)

      <cfquery >
      SELECT ....
      WHERE cst_AccountNum = '#attributes.accountNum#'
      AND
      #REReplaceNoCase("cst_Phone","[,.-]", "", "ALL" )# =
      '#REReplaceNoCase("#attributes.telephone#","[,.-]", "", "ALL" )#'

      </cfquery>

      Get what I'm trying to do?

      Thanks,
      Chris