>>>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
It's Time to get a gun.
That's what I've been thinkin.
I think I can afford one, If I do a little less Drinkin.www.TrueGeeks.com