select SUBSTRING(EmailAddress,1,CHARINDEX('@',EmailAddress,1)-1) as [Email Address without domain],SUBSTRING(EmailAddress,CHARINDEX('@',EmailAddress,1)+1,len ...
I'm having to hack a report together to pull data from another field in the same table. The row selection is going to be based on various elements in the above 'foreignkey' field - elements 1, 2, 4 & ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results
Feedback