I am working on a 'Find' screen for a form. I am trying to return all names that match the characters typed in a textbox. The data is on a SQL Server backend. I am trying to use the 'like' operator in a remote parametized view but it doesn't seem to work. I have set ANSI to off. The filter in the view designer is:

pr_name like ?qName

It only seems to work if I type in the exact expression.

Perhaps there is a better way to do this?

TIA

John