1:
declare @e nvarchar(500)
set @e=''
select @e=@e+ right(email,len(email)-charindex('@',email))
from uTable
select @e2:如果是 數據型:
select f1-f2 as diffs from uTable
如果是字符型
select replace(f1,f2,'') as diffs from uTable
declare @e nvarchar(500)
set @e=''
select @e=@e+ right(email,len(email)-charindex('@',email))
from uTable
select @e2:如果是 數據型:
select f1-f2 as diffs from uTable
如果是字符型
select replace(f1,f2,'') as diffs from uTable
declare @e nvarchar(500)
set @e=''
select @e=@e+ '/'+ right(email,len(email)-charindex('@',email))
from uTable
select left(@e,len(@e)-1)
2.HOTMAIL.COM
3.21CN.COM.CN
这是我想要的结果1,2,3是自动ID