Hi, I'm sure I have had a solution to this problem before but I just can't find it. Anyway, I want to only include certain parts of a where clause if the data I am testing is of a cetain value. The best way for me to explain it is to include some code (that doesnt work but should help).
((If @JobsIndustryiD > 0) JobsIndustryiD = @JobsIndustryiD)
((If @JobVerticalMarketiD > 0) JobVerticalMarketiD = @JobVerticalMarketiD)
((If Len(@JobVerticalMarketiD) > 0) JobVerticalMarketiD = @JobVerticalMarketiD)