>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%".