Using PatIndex and CharIndex like the InStr function

Question

I tried using Instr for this, but didn't work, so I found the supposed to be equivalent using PatIndex and CharIndex, however, I'm having an issue here when I run this:

SELECT PATINDEX(`http://www.stackoverflow.com`,'%.com%')

This returns 0

SELECT CHARINDEX(`http://www.stackoverflow.com`,'%.com%')

This returns 0

SELECT PATINDEX(`http://www.stackoverflow.com`,'.com')

This returns 0

SELECT CHARINDEX(`http://www.stackoverflow.com`,'.com')

This returns 0

How do I get this to work like InStr ?

If my calculation is correct, it should return 25 instead of 0, anyone know why it's not?

GSerg · Accepted Answer · 2013-08-17 00:43:25Z

3

You've got it reversed.

select patindex('%.com%', 'http://www.stackoverflow.com');
select charindex('.com', 'http://www.stackoverflow.com');

answered Aug 17, 2013 at 0:43

GSerg

78.8k18 gold badges173 silver badges377 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Fatih Çelik · Accepted Answer · 2016-01-20 12:52:35Z

1

Be careful while using those functions in computed column functions. Because they are non-deterministic.

https://technet.microsoft.com/en-us/library/aa214775(v=sql.80).aspx

answered Jan 20, 2016 at 12:52

Fatih Çelik

5417 silver badges16 bronze badges

Collectives™ on Stack Overflow

Using PatIndex and CharIndex like the InStr function

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related