SQL - Dispose of @domain.com 1

[tinapa]

hi guys, ive been trying to extract names from email address field.

if i have emails like these:

adam.peter@yah123.com
esther.oliver@test678.com
.
.
.

how to i write a sql to make it to look like this:

adam peter
esther oliver

i been using replace,trim functions but it only gets me so far of eliminating the '@' sign.

any ideas guys?

thanks

 

[r937]

SELECT REPLACE(
         SUBSTRING(email,1,CHARINDEX('@',email)-1)
           ,'.',' ')

r937.com | rudy.ca
Buy my new book Simply SQL from Amazon

 

[tinapa]

hi r937,

it works!, ur awesome!

tnx a lot.