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)

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? ie: