>>>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?
>>
>>Are you using = if so try LIKE.
>>
>>select * from mytable where fielda like '%whatevere%'
>>
>>HTH
>>Jeff
>
>in Craig's case you would need upper(fielda) like upper('%whatever%')

Correct--I did not read that part. Answered before I was finished. DUH!

Jeff