>>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.
My tests showed, much to my surprise, that LIKE was not optimized.