<div>
what version of SQL Server is it? <br />
<br />
At SQL 2012 <a href="https://msdn.microsoft.com/en-us/library/hh974669(v=sql.110).aspx" rel="ugc">TRY_CAST()</a> is available.<br />
<br />
select<br />
*<br />
from table1<br />
where try_cast(column1 as date) IS NULL<br />
<br />
but the problem with this is performance my be poor on a large table (but the same is likely to be true with alternatives).
</div>


what version of SQL Server is it?

At SQL 2012 TRY_CAST() [https://msdn.microsoft.com/en-us/library/hh974669(v=sql.110).aspx] is available.

select
*
from table1
where try_cast(column1 as date) IS NULL

but the problem with this is performance my be poor on a large table (but the same is likely to be true with alternatives).

<div>
but, we can use regular expressions in .net since 1.1 release
</div>


but, we can use regular expressions in .net since 1.1 release

<div>
yes, in .Net, but not in sql server directly<br />
using .net means you would have to bring all the relevant table data from the server to the .net app
</div>


yes, in .Net, but not in sql server directly
using .net means you would have to bring all the relevant table data from the server to the .net app

<div>
<div class="content wysiwyg-content">
Ok, how can I write a regular expression which can tell me a particular row data is not correct date, out of a column , in a table with millions of records <br />
<br />
column 1 <br />
01-Jan-15<br />
01-Jan-15<br />
01-Jan-15<br />
01-Jan-15<br />
01/Jan/15<br />
<br />
what regular expression will return me row no. 5 from above table.
</div>
</div>


Ok, how can I write a regular expression which can tell me a particular row data is not correct date, out of a column , in a table with millions of records 

column 1 
01-Jan-15
01-Jan-15
01-Jan-15
01-Jan-15
01/Jan/15

what regular expression will return me row no. 5 from above table.

regular expression in sql server

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.