Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Analysis Server and Reporting Services (2005)
 Parameter help

Author  Topic 

PatDeV
Posting Yak Master

197 Posts

Posted - 2007-05-02 : 08:27:34
Hi,

I want to use parameter and would like get result like this

I have access file that has linked tables of oracle database.

I am trying to create prameter but oracle doesn't like named parameter so I am trying to use " ? " as parameter.

I have query similier to following:

select user_NM, user_Id, Address
from user
where user_NM like ?

but it doesn't work that way. how can i put ? or parameter to act such i can look for any thing such as if i type A then it should give me everything with starting or has A in name?

thanks
   

- Advertisement -