Search specified spot in string for specified character

[mkallover]

I'm trying to figure out how I can search a field in a table for a specific character (in this case a 'P') in a specific position (second from the end.)

I've looked at CHARINDEX but I don't think that will get me what I need. I'm thinking maybe I'll have to use a combination of things.

Any ideas?

 

[SkipVought]

Hi,
[tt]
Where MID([Your Field],Len([Your Field])-1,1)='P'
[/tt]


Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[mkallover]

Thanks Skip.

What is the difference between MID and SUBSTRING? After posting this I managed to find some info on SUBSTRING and it look like the same type of function.

 

[PWise]

SUBSTRING is for SQL Server

 

[SkipVought]

Also Oracle & DB2 use SUBSTR.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}