Doing a LIKE comparison in a WHERE condition

Hi there,

Is it possible to do a LIKE check in a where condition. I'm thinking something like

MyValue LIKE '%[22]%'

Where it would match a MyValue string which contained '[22]'.

Thanks, Sam

where condition

Yeah ok so what I suggested is exactly how you do it:

MyValue LIKE '%[22]%'

0 votesVote for this answer Unmark Correct answer

Where are you trying to do this? In back end code or in a webpart property?

0 votesVote for this answer Mark as a Correct answer

In a web part property

0 votesVote for this answer Mark as a Correct answer