I am selecting using teh following Where clause:
WHERE (SS.statusName = 'Signed Off' OR SS.statusName = 'Closed') AND S.receivedFromTypeID = '1' AND (S.submissionDetails LIKE '%' + @Keyword + '%')
ORDER BY M.meetingDate, S.agendaNo
The only parameter that is passed in is for @Keyword, but the LIKE does not seem to be working for this.
Anyone know why?
No comments:
Post a Comment