<div>
DECLARE @email varchar(400)<br />
SET @Email = 'aneeshattingal@hotmail.co<wbr />m'<br />
SELECT SUBSTRING(@Email, Charindex('@',@Email)+1,Le<wbr />n(@Email)-<wbr />Charindex(<wbr />'@',@Email<wbr />)+1)
</div>


DECLARE @email varchar(400)
SET @Email = 'aneeshattingal@hotmail.com'
SELECT SUBSTRING(@Email, Charindex('@',@Email)+1,Len(@Email)-Charindex('@',@Email)+1)

<div>
if you need '@' then <br />
<br />
<br />
DECLARE @email varchar(400)<br />
SET @Email = 'aneeshattingal@hotmail.co<wbr />m'<br />
SELECT SUBSTRING(@Email, Charindex('@',@Email),Len(<wbr />@Email)-Ch<wbr />arindex('@<wbr />',@Email)+<wbr />1)
</div>


if you need '@' then


DECLARE @email varchar(400)
SET @Email = 'aneeshattingal@hotmail.com'
SELECT SUBSTRING(@Email, Charindex('@',@Email),Len(@Email)-Charindex('@',@Email)+1)

<div>
thanks - however, I need this to be an update query......???
</div>


thanks - however, I need this to be an update query......???

<div>
<br />
update yourtable set domain=right(email,len(ema<wbr />il)-charin<wbr />dex('@',em<wbr />ail))
</div>



update yourtable set domain=right(email,len(email)-charindex('@',email))

<div>
yep - of course - have a silly moment - just figured it out myself - thanks again :)
</div>


yep - of course - have a silly moment - just figured it out myself - thanks again :)

<div>
how about address lines?? extracting a postcode from a address?
</div>


how about address lines?? extracting a postcode from a address?

<div>
<div class="content wysiwyg-content">
Hello peeps!<br />
Am in desperate need to extract all domain names from an email field - so mel@mel.com will return @mel.com - any ideas on what the sql code will be to do this?<br />
Thanks<br />
<br />

</div>
</div>


Hello peeps!
Am in desperate need to extract all domain names from an email field - so mel@mel.com will return @mel.com - any ideas on what the sql code will be to do this?
Thanks



Email Domain Extraction

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.