by Michael Dinowitz
In my article "Comparisons With CFIF," in the last issue of the Fusion Authority News Alert, I wrote about the best way to do text comparisons within a CFIF statement. While I do say that these numbers are only for text comparisons, I don't show the speed differences when one of the values in a comparison is a number. The reason for this is that the standard CFIF IS statement is going to be faster than any function you could use. This was stated in the quote:
"I believe that this statement does a few evaluations before trying to do any sort of comparison. The first evaluation is to see if either value is a Boolean and the second is to see if either is a Numeric. If they are one of these data types, then the actual comparison goes rather fast."
I'm including the quote in this specific context so that there should be no misunderstandings. Only use functions for comparison within a CFIF when dealing with text data, never with numerics or booleans.