Selecting a Parameter using LIKE keyword

Hi JMcCon

Please modify your condition as below

select * form tablename where columnname like '%'+@Criteria+'%'