用SQL语句从邮箱地址这一列里把域名取出,也就是要把所有@后面的字符串全部取出返回
SUBSTRING(OrgId,(CHARINDEX('@',OrgId)+1),LEN(OrgId) - (CHARINDEX('@',OrgId))) AS DomainName
用SQL语句从邮箱地址这一列里把域名取出,也就是要把所有@后面的字符串全部取出返回
SUBSTRING(OrgId,(CHARINDEX('@',OrgId)+1),LEN(OrgId) - (CHARINDEX('@',OrgId))) AS DomainName
Leave a Reply
You must be logged in to post a comment.