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 |
programer
Posting Yak Master
221 Posts |
Posted - 2010-09-27 : 15:11:21
|
SELECT ID, UserId, IdSifra, Priimek, Ime, Posta, Kraj, Delovno_mesto FROM dbo.tbl_zaposleni Where First=@First or Last=@LastMy parameter is First and Last.I've used "or"But does not work.Personal data:Id, First, Last1 test1 test22 test3 test4If I want to find information in the fields "First", works, but if the first field, leave blankand I in another field "Last" to find information but does not work.Why not? |
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2010-09-28 : 11:27:50
|
How do you pass the values to the parameters?MadhivananFailing to plan is Planning to fail |
 |
|
|
|
|