Jayesh:

So, in your example below, if I query on iField1 (passing "%" as the parameter for the other two values), presume you have to convert vp_iField1 to a string too? I haven't tried this yet but if this works, this is way cool!

Thanks for sharing this with me.

Best


>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!