Hi,
I have sql server coulmn which stores all mailaddress.I want to filter out only the part of the string after @ symbol i.e I want to filter all domain name.Suppose mail-d is [email protected] then it should give only @gmail.com.Plz help me urgently

Satish

Hi Satish

u can use instr and mid function for extracting the part
first use instr function to get the location of @ symbol and then use
mid function for extract the string

hth

ashok sharma

Here you have sathish

Sub Get_EMail()


sEmail = "[email protected]"

arTemp = Split(sEmail, "@")

sDomain = arTemp(UBound(arTemp))
End Sub

Cheers
Shasur

http://www.vbadud.blogspot.com

or

domain = Right$(myString, len(myString)- instr(1,myString,"@"))

"There are two ways to write error-free programs. Only the third one works."
Unknown