• This seems to work:

    create table #TestTable(

    TestStr varchar(10)

    );

    go

    insert into #TestTable

    values ('5+'),('1+'),('3-');

    go

    select * from #TestTable where TestStr like '%+%';

    go

    drop table #TestTable;

    go