>Hi Nadya,
>
>I did not read your original carefully enough, so I missed some of your points.
>
>If the number of parameters and indexes is a concern, I suggest you go for second approach. Is the "_" meant to be a space character? Anyway, you can shorten the lcName expression:

>lcName = padr("GREE",25) + padr("MAR",20) +padr("",1)
>select ... from ... where cl_name + cf_name + cm_Initial = lcName
>

>If you skip the middle name:

>lcName = padr("GREE",25) + padr("MAR",20)
>select ... from ... where cl_name + cf_name = lcName
>

>
>In my tests, the LIKE operator was never optimized.
>

Tore,

I think, LIKE operator is optimized and it is sure optimized in VFP9 (we're using VFP8 here, but will get 9 shortly). And I can not use space, I have to use LIKE and "_" (underscore represents any character). I think, you see by yourself why space would not work.

However, I was thinking, that you're right, so before going home I started to re-code back to the original idea. I think, I may need to run more tests. I believe, the bigger result I return, the slower the requery is for my view.