find row that causes cast error
Posted on 2007-07-20
I have a huge table (all fields are varchar(max), which I want to insert into a smaller table (all fields are smalldatetime).
I use this:
cast( dbo.transformDate( DATE ) as smalldatetime )
to cast the original varchar(max) fields. This works fine for the majority of fields. Unfortunately, one or several rows contain 'rubbish'. I am just wondering what the best strategy is to find the culprit row(s) given my very large table.
PS: The UDF transformDate works fine.