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.

>>Hi Nadya,
>>
>>Your first select is fully optimized, no need to rewrite it in any way.
>
>Hi Tore,
>
>I wanted to reduce number of view parameters and the complexity of the view. I also wanted to minimize number of indexes. What do you think about an index on Middle Initial? I think, we don't need to have it at all. But you're basically suggesting, that I have to return to the previous version of the view?
>
>Thanks again.