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: > > > > SELECT x > > FROM table > > WHERE y IN (a,b,c) > > > > > > > > -- > > Scott Stewart > > IT Consultant/ColdFusion Developer > > 4405 Oakshyre Way > > Raleigh, NC 27616 > > (919) 874-6229 > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327441 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4