I am using a remote view connecting to SQL server with the select statement

select * from DB1
where field_name like ?parameter


I am using this view to populate a grid with either a list of items like the parameter 'ABC% or an exact match of the parameter 'ABCD'

It says in BOL that you can use a wild card, but it's not mandatory

James