I never use the ?cLastName + '%' syntax in the creation of a remote view. I always add the wildcards to the parameter. That way I can put wildcards anywhere I want in the parameter instead of hard coding it into the view SQL.
>Hi Mark,
>
>Our framework handles local and remote views differently, or I would just use the same syntax. I'll probably have to check if the view is a remote view, and if so, add the "%" to the variable as you described. I could have sworn the remote view worked as is a year ago, and that's the main reason for my question. Do you know how Oracle would handle a ''+'%' as in my example? Thanks.
>
>>Why don't you just have LIKE ?cLastName, etc. in the WHERE clause then set cLastName = alltrim(ThisForm.txtLastName.Value) + "%"
Mark McCasland
Midlothian, TX USA