create procedure MySP
@var varchar(20) = null
as
if @var = null
Select * from news_items
else
Select * from news_items
where division = @var
Steve Jones
http://qa.sqlservercentral.com/columnists/sjones
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com