Brian [..] > set @querystring = 'SELECT aField, bField, cField, dField FROM aTable > WHERE 1=1 ' > > if(@bcondition1 is not null) > begin > set @querystring = @querystring + 'AND aField = > @aValue ' > end [..] > exec (@queryString) That was exactly what I was looking to do. Many thanks! [..] Regards Chris Marsh