I have a parameter (@Phrase) that may be filled. It has properties set to Allow Null.
My issue is with my dataset (query). I don't know how to make it run if the @Phrase is Null.
Here is my Where clause:
WHERE i.InsuredID in(@ClientID)
AND LossDate between @FromDate and @ToDate
AND co.FileName like '%@Phrase%' ----- this isn't working when nothing is put into the Parameter.