Home Forums SQL Server 2008 T-SQL (SS2K8) Query for a plus sign RE: Query for a plus sign
Lynn Pettis
SSC Guru
Points: 442467
More actions
December 11, 2012 at 5:33 pm
#1567650
This seems to work:
create table #TestTable(
TestStr varchar(10)
);
go
insert into #TestTable
values ('5+'),('1+'),('3-');
select * from #TestTable where TestStr like '%+%';
drop table #TestTable;