The problem with my alternate view appears to be due to the fact that there WERE imbedded blanks in the concatenated field. With the blanks gone it worked. Thanks for all the advice. Sandy Weller ________________________________________________ Also known as an INDEXED view. Running 7.2.5 under MVS I get a FOC269 error tellng me EQUALITY SCREENING TESTS MUST BE PROVIDED IN AN INDEXED VIEW Thanks Sandy Weller --------------------------------- Do you Yahoo!? Yahoo! Mail Address AutoComplete - You start. We finish.