which one has better performance: patindex and like

Asked Oct 16 '14 at 16:29

Active Oct 16 '14 at 16:29

Viewed 173 times

in a query where condition clause. to check if string a contain b, I have a few options with T-SQL(Sybase):

a like '%b%'
charindex(b,a)>0
patindex('%b%', a)>0

which one has better performance?

asked Oct 16 '14 at 16:29

KentZhou

I like charindex but it will depend on your data and the query it is in. – paparazzo Oct 16 '14 at 16:36
Seems easy enough to test yourself. There are too many variable to give you a 100% correct / non-opinionated answer. – Steve Oct 16 '14 at 22:46
I have same question for sqlserver, did anyone get an answer? – Harshad Vekariya Aug 27 '19 at 11:33

0 Answers0