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
 several matches in if

Author  Topic 

rnbguy
Constraint Violating Yak Guru

293 Posts

Posted - 2007-04-17 : 21:02:05
i dont know why this has slipped my mind but how would i say,

if @test = 'a' or @test = 'b' or @test = 'c'

in a shortted way?

dinakar
Master Smack Fu Yak Hacker

2507 Posts

Posted - 2007-04-17 : 21:19:13
IF @test IN ('a', 'b', 'c',...)

not necessarily the best, but could be short.


************************
Life is short. Enjoy it.
************************
http://weblogs.sqlteam.com/dinakar/
Go to Top of Page
   

- Advertisement -