SELECT AdjudicationDetailID,(AAT.Description+' '+CAST(AAD.AdjudicationDetailID AS VARCHAR(10))+' '+CONVERT(VARCHAR(10),AAD.MeetingDate,103)+' : '+AAD.MeetingTime) AS AdjudicationDetailS  FROM App.AdjudicationDetails AAD INNER JOIN App.AdjudicationType AAT ON AAD.AdjudicationTypeID=AAT.AdjudicationTypeID WHERE(CASE WHEN isnull(@SearchText,'')<>'' THEN CASE WHEN AAD.AdjudicationDetailID LIKE '%' + @SearchText + '%' THEN 1 WHEN AAT.Description LIKE '%' + @SearchText + '%' THEN 1 WHEN CONVERT(VARCHAR(101),AAD.MeetingDate,103) LIKE '%' + @SearchText + '%' THEN 1 WHEN AAD.MeetingTime LIKE '%' + @SearchText + '%' THEN 1 ELSE 0 END ELSE 0 END)=1