格式化邮箱

来源：互联网发布：网络重载连接器hdc cm 编辑：程序博客网时间：2024/05/02 01:06

update EmailAddress set emailaddress=RTRIM(LTRIM(LEFT(emailaddress,CHARINDEX(';',emailaddress)-1)))

where CHARINDEX(';',emailaddress)>0

update EmailAddress set emailaddress=RTRIM(LTRIM(LEFT(emailaddress,CHARINDEX(',',emailaddress)-1)))

where CHARINDEX(',',emailaddress)>0

update EmailAddress set emailaddress=SUBSTRING(emailaddress,0,CHARINDEX('/',emailaddress))

where SUBSTRING(emailaddress,CHARINDEX('@',emailaddress)+1,1000) like '%@%' and emailaddress like '%/%'

update EmailAddress set emailaddress=SUBSTRING(emailaddress,0,CHARINDEX(' ',emailaddress))

where SUBSTRING(emailaddress,CHARINDEX('@',emailaddress)+1,1000) like '%@%' and emailaddress like '% %'

update EmailAddress set emailaddress=SUBSTRING(emailaddress,0,CHARINDEX('.com',emailaddress)+4)

where SUBSTRING(emailaddress,CHARINDEX('@',emailaddress)+1,1000) like '%@%' and emailaddress like '%.com%' and not emailaddress like '%.com.%'

update EmailAddress set emailaddress=SUBSTRING(emailaddress,0,CHARINDEX('.com.cn',emailaddress)+4)
where SUBSTRING(emailaddress,CHARINDEX('@',emailaddress)+1,1000) like '%@%' and emailaddress like '%.com.cn%'

0 0