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 |
|
vux
Starting Member
45 Posts |
 Posted - 2004-07-21 : 00:05:54
|
| I want to make a filter:WHERE table.OrgID IS IN (1243, 1346, 3444, 4355,.....)OgrID is a Char(4)how is the right syntax to this?thank you! |
|
|
kselvia
Aged Yak Warrior
526 Posts |
Posted - 2004-07-21 : 00:13:27
|
| You were close. Should be:WHERE table.OrgID IN ('1243', '1346', '3444', '4355',.....)--KenYour Kung-Fu is not strong. -- 'The Core' |
 |
|
|
vux
Starting Member
45 Posts |
Posted - 2004-07-21 : 00:30:51
|
| thank you!I finally found a transact sql eBook and also the Transact Reference on the SQL 2000 Serverwill look these little things upo there first......so you guys will only get the complicated stuffthx |
|
|
|
|
|
|
check if a number is in a certain set of numbers