MSSQL LIKE operator work with parameter values
without parameter: LIKE '%abc%'
with parameter: LIKE '%'+@searchString+'%'
Achievement provides the only real pleasure in life
without parameter: LIKE '%abc%'
with parameter: LIKE '%'+@searchString+'%'
Posted by
SF
at
3:53 pm
0
comments
Labels: keyword search, LIKE, MSSQL, operator, parameter