• 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_]%'