Friday, June 30, 2017

using like in dynamic sql parameters

add the '%' top the parameter value

set @p_SUBJECT = '%' +  @p_SUBJECT + '%'

No comments:

Post a Comment