Alternative to IF in this case

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

General SQL Server Forums

New to SQL Server Programming

Alternative to IF in this case

Author

Topic

norty911
Starting Member

41 Posts

Posted - 2007-10-24 : 09:46:22

Hey guys,
What would be a better / more elegant solution to something like

IF(@areaCode = '111' OR @areaCode = '222' 0R @areaCode = '333')
BEGIN
//do something
END

that uses less OR's in an IF statement?

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2007-10-24 : 09:49:22

if (@areaCode in ('111', '222', '333'))

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp
SSMS Add-in that does a few things: www.ssmstoolspack.com