query help

[dbsql]

Hi i am trying to query oracle from SSRS and so far successful but when i try to do this:

select testname, testid
from test
where testname like '%'+upper(?) +'%'

then get error saying that invalid number i know i could do something like that in SQL but having trouble in oracle!

i am doing that so in parameter user don't have to put % !!

thanks


Thanks!!

 

[ptheriault]

You should ask that question in the Oracle forum.

forum759

- Paul

- If at first you don't succeed, find out if the loser gets anything.