No. Inside one trigger you can test whether a column was changed by using the UPDATE(fieldname)...

It could help a lot if you posted a screen shot of the "schedule" dialog box for the job/maintenance plan you ran. There might be a relevant detail in there.

I've long since dropped the WHERE clause. The SELECT statements in my last post all return the error, without any WHERE criteria included at all.

I tried putting that statement in...

Thanks, PW. That looked perfect at first.

I tried your suggestion:

Select Convert(datetime, Case OpeningDate When '' Then NULL Else OpeningDate End) As FormattedOpeningDate

as well...

Basically, no, it doesn't.

This query you gave me:

(SELECT Mattername, OpeningDate

FROM tm5user.Matter

WHERE ISDATE(OpeningDate) = 0)

returns just the records where OpeningDate='' . If I add the criteria AND OpeningDate<>'' , then I get no records.

Getting...

The dates (again, in a varchar column) are all in m/d/yyyy format, like this:

3/10/2004

11/9/2003

2/6/2005

and I still get a result set in QA, with LOOKS right; the converted column looks like...