Adequate and nice to learn

To get the exact result

select * from #Like_Test

where Col1 Like '%Cu[_]%'

‘_’ is escape so

[_] is the valuable one