create table #Like_Test( Col1 varchar(5) )
insert #Like_Test values('_Cus')
insert #Like_Test values('Cus_')
insert #Like_Test values('C_us')
insert #Like_Test values('Cus')
insert #Like_Test values('Cu_s')
select * from #Like_Test where Col1 Like '%Cu_%'
How can we really get the row with value as "Cu_" then?
(I mean the last record in the above table)
Something like this doesnt works..
select * from #Like_Test where Col1 Like '%[Cu_]%'