Split the value in table column sql server 2008?

Question

Table name: Table1

The table has 2 columns

Id   Name

1     1|admin|abs@yahoo.com
2     22|user|aaaaa@yahoo.com

From the Name column I want to fetch the email adress

Result:

Name
abs@yahoo.com    
aaaaa@yahoo.com

possible duplicate of [T-SQL: Opposite to string concatenation - how to split string into multiple records](http://stackoverflow.com/questions/314824/t-sql-opposite-to-string-concatenation-how-to-split-string-into-multiple-recor) — Lieven Keersmaekers, May 09 '11 at 11:20

score 1 · Accepted Answer · answered May 09 '11 at 11:25

1

try this one

select SUBSTRING(name,CHARINDEX('|',name, CHARINDEX('|', name)+1)+1,100) from  Table1

answered May 09 '11 at 11:25

Adnan M. TURKEN

1 Answers1