DOES ANYONE KNOW THE DIFFERENCE BETWEEN

"WHERE fld IN"

AND

"WHERE fld CONTAINS"

?

Thanks!

CONTAINS is searching the contents of the field for a supplied character string
IN is matching the entire contents of the variable to a file which contains a list of acceptable values for that field.
heres some tech info

This message has been edited. Last edited by: susannah,