Hello demos,
quote:
SELECT * FROM TableA WHERE ColumnB IN (@SomeVariable)and the variable can be = 1 or = 1,2,3 etc
SELECT * FROM tablea WHERE ColumnB BETWEEN lower_bound and upper_bound
Cheers,
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]