Before issuing the query...
qName=ALLTRIM(qName)+'%'
>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