CODEWITHSUNDEEP
sql-server
charan
charan

Reputation: 29

substring charindex not working

DATA:

PFP_110
PFP_111
IFC_NP
IFC

Expected Output:

PFP
PFP
IFC
IFC

  select MemberName,
  SUBSTRING(MemberName,CHARINDEX('_', MemberName),4) from 
  SRC_TEST

but not getting the expected output

Thanks in Advance

Upvotes: 0

Views: 712

Answers (2)

charan
charan

Reputation: 29

select MemberName, REPLACE(SUBSTRING(MemberName,1,CHARINDEX('', MemberName)),'',''), * from SRC_TEST

Upvotes: 0

Lukasz Szozda
Lukasz Szozda

Reputation: 176144

You could use LEFT:

select MemberName,LEFT(MemberName,CHARINDEX('_', MemberName + '_')-1) 
from SRC_TEST;

DBFiddle Demo

Upvotes: 3

Related Questions