>>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%')
Mark McCasland
Midlothian, TX USA