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.
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 thisI 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, Addressfrom userwhere 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 |
|
|
|
|