<div>
<div class="content wysiwyg-content">
Hi Experts,<br />
<br />
This query isn't working for me.<br />
<br />
SELECT &nbsp; &nbsp; CHARINDEX(INDIVIDUAL_EMAIL<wbr />, '@', 1) AS Expr1<br />
FROM &nbsp; &nbsp; &nbsp; &nbsp; TBL_INDIVIDUAL<br />
<br />
Basically I want find all the test email addresses w/o &quot;@&quot; in the email address and delete them. &nbsp;I figured if the CHARINDEX returned 0 I could delete, but I'm not getting address addresses that have the &quot;@&quot; at all!<br />
<br />
Any help is appreciated.<br />
<br />
Thanks,<br />
Full Williams
</div>
</div>


Hi Experts,

This query isn't working for me.

SELECT     CHARINDEX(INDIVIDUAL_EMAIL, '@', 1) AS Expr1
FROM         TBL_INDIVIDUAL

Basically I want find all the test email addresses w/o "@" in the email address and delete them.  I figured if the CHARINDEX returned 0 I could delete, but I'm not getting address addresses that have the "@" at all!

Any help is appreciated.

Thanks,
Full Williams

CHARINDEX Not working

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.