Re: T-SQL Stored procedure, "In" predicate in a "Where" clause

Yep. Anything you can run in a query, you can run in a Proc (plus more!). Thanks, Eric Cobb http://www.cfgears.com Scott Stewart wrote: > Hey all, > > > > Quick question, in T-SQL (MS SQL Server) can you put an "in" predicate in a > "Where" clause inside a stored procedure? > > > > i

T-SQL Stored procedure, "In" predicate in a "Where" clause

Hey all, Quick question, in T-SQL (MS SQL Server) can you put an "in" predicate in a "Where" clause inside a stored procedure? ie: SELECT x FROM table WHERE y IN (a,b,c) -- Scott Stewart IT Consultant/ColdFusion Developer 4405 Oakshyre Way Raleigh, NC 27616 (919) 874-