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!!