You use expression in the WHERE clause and use the LIKE operator.
For example, Create the view that looks like this.
SELECT *
FROM MyTable
WHERE ALLT(STR(iField1)) LIKE ?vp_iField1
AND ALLT(STR(iField2)) LIKE ?vp_iField2
AND ALLT(STR(iField3)) LIKE ?vp_iField3
If you need to query the table with iField1, you can pass '%' in vp_iField2 and vp_iField3.
>I would like to create a single view that can be used with several integer column parameters. On each occasion, I only need to query based on a single integer column.
>
>Is there any numeric wildcard value that I can use on the other columns when I am querying for just one known value on a single column?
>
>If not, is there an accepted best practice when effectively replicating a view multiple times where only the query column is different?
>
>Thanks!
- Jayesh