Charlie Arehart

If you have to test a condition against many values in a CFIF, you may be tempted to write out a very long condition, such as:

CFIF FORM.STATE IS "MA" OR FORM.STATE IS "VT" FORM.STATE IS "AK" ...

This quickly becomes unwieldy. There is an alternative approach. Simply use the LISTFIND (or LISTFINDNOCASE) function instead, as in:

CFIF LISTFIND("MA,VT,AK",FORM.STATE)

Note that the list of values is specified first, then the value to search for in the list. Also, the LISTFIND function presumes you are using commas to separate list values, but if you need to test strings that contain commas, you can specify an alternate delimiter as the 3rd argument in the function.

Finally, be careful about the case (upper/lower) of both comparison strings. If the value of FORM.STATE were "ma", the condition would not be true. To cause the condition to ignore case, use LISTFINDNOCASE instead.

Charlie Arehart Education Director, Fig Leaf Software