Thursday, January 30, 2014

Selecting a Parameter using LIKE keyword

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