You are going in the right direction !!!

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