>>>Craig ---
>>>
>>>What type of view? Remote? Local? What is the back-end database? If I assume SQL Server....
>>>
>>>The % acts as a wildcard in SQL Server, ie, SELECT * FROM pubs WHERE author like "w%". It is case-insesitive.
>>>
>>>
>>>
>>>>I am attempting to use the % operator in a SQL SELECT and a view parameter, but either I get no records returned or get an error, "Function arguement type, value, or count is invalid." I also want this to be case insensitive. Has anyone had tried to do this?
>>
>>
>>It is a Fox table. But, I need to use a view parameter. Something like ?"%w%".
>
>
>Have you tried Macro Substitution a="%30%"
>
>SELECT * FROM mytable WHERE mytable.ordernu LIKE ?a
>
>This works on mine
>
>HTH
>Jeff


That's where I was heading next. I've been trying to do this with the view designer, but its looking like it is another designer limitation.