Thanks, unfortunately I can't use the like clause because essentially what I am trying to do is supply a parameter to the below clause that causes all rows to be...

ah ok, that makes sense then, thanks for the response.

In that case is there any parameter that can be supplied to a 'field1 =" clause so that it returns all...