Selecting a Parameter using LIKE keyword

Hi, JMcCon

It look's fine, why u think it's does not working...

Declare @test nvarchar(10)

set @test='Abcde'

select * from table_name where column_name like '%'+@test+'%'

its working.....