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?