CODEWITHSUNDEEP
sqlsql-server
IMMORTAL
IMMORTAL

Reputation: 2857

Like Query not working when I Use "?" character

My SQL query is like this 

create table Manager(id int, managerid varchar(3) , managername varchar(50))

insert into Manager(id,managerid,managername)values(123,'A12','Mangesh')
insert into Manager(id,managerid,managername)values(54321,'A23','Sagar')
insert into Manager(id,managerid,managername)values(334,'C34','Ahmad')
insert into Manager(id,managerid,managername)values(456,'A45','Mango')
insert into Manager(id,managerid,managername)values(567,'B56','Sandesh')

my Like query is this

select * from Manager where id LIKE '%4321%'

this query gives me this record 

id     managerid  managername 
54321  A23        Sagar

but when I try to run such kind of query it does not give me any record i.e. zero record count but actually there is one record Query is :

select * from Manager where id LIKE '%?4321%'

what is wrong with this?

sql fiddle sql query

Upvotes: 2

Views: 120

Answers (2)

Jesuraja
Jesuraja

Reputation: 3844

Try this:

SELECT * FROM Manager WHERE id LIKE '%_4321%'

Upvotes: 4

Martin Smith
Martin Smith

Reputation: 453543

Use _ not ? for a wildcard indicating "any single character".

Upvotes: 8

Related Questions