Quoting myself :

Declare @a as datetime

Select @a = cast(getdate() as varchar(10))

Select @a

try

Select * from dbo.tblShipping_rpt_date where isdate(shippg_rpt_dt) = 0

this will tell you which row of data has an invalid...

The real question is why do you want to many different tables that keep the same information?

Can we see the proc code and the full asp code?

I'll bit on this one too :

Feelings are Feelings and we happen to have them too. You just heppen to express them more (that too is proven).

when you copy the valid records, this is where you convert back... and is also where you drop the invalid dates.

NP.

He didn't fuel anything.

Now I have the last word .

L8r sushila.

That's how I like it...after I found the solution, not while I'm facing the problem .

Glad we could help.

The dragon gives him away... never thaught of him as a her.

Maybe but you speak enough for all of them .

ssword, he you want to be referred as a she, get a female nickname... just to be on the safe side.

This is the simplest solution for this. however this is still the wrong method of doing this. There comes a point where laziness doesn't pay up. Create...

Yup, that good old cartesian result .

IIRC = If I remember correctly.

Here is where the person is at the moment he speaks .