Ken,

Your solution was fine, as well... I was responding to Fintan who apparently didn't read either of your posts very well.

Look at the SELECT!  That's where the meat of Ryan's example is...

Ryan's post was an example to demonstrate the method for using the "mon yyyy" format as a datetime that you...

Understood... you're not really changing the column type... just making it so it won't take bad data.  Most vendor apps can withstand this type of change even if they've made...

Nice.....

You can really tell that Time has had to deal with this before I share Ryan's sentiment... nice job!

Gail, thanks for the feedback......

I always wait on "Very Urgent" requests like this that have such a simple basis... it usually means that someone is taking an SQL test as part of an interview and,...

Heh... what if there was nothing from yesterday, either?  Peter's solution is good.

But, why is there even a need to check the date?  Tomorrow's news will likely not happen today.

Sorry, I don't know Neetal... I'm pretty much at a loss on this one...

Can anyone else help on this?  I'm neither and sp_oa Ninja nor a mail ninja...

If it was working before, then the devil is in the data...

What creates the IP address on the SMTP Server?  If it's DHCP and someone rebooted it, it may...

Gail,

I know you said you checked, but try this on the table that produces the error...

SELECT *

FROM Test

WHERE AMOUNT LIKE '%[^0-9]%'

Yes, it's possible...

EXEC Master.dbo.xp_CmdShell "DIR d:\path\*.trn,d:\path\*.bkp /s/b"

If you actually want to use the file names, create a table with a nice wide VARCHAR column and do this...

INSERT INTO yourtable (widevarcharcolname)

EXEC...

I absolutely agree... for man-power scheduling purposes, ok... for simple reporting, doesn't matter.

Here's another way to find what the day of the week is without regard to @@DateFirst...

SELECT DATENAME(dw,GETDATE())

Or, you could do this...

SET @variable = ISNULL(@variable,0)

... for inline code, you don't even need to change the value... just use the formula...

SELECT ISNULL(@variable,0)

FROM yada yada

... OR...

SELECT yada yada

FROM wgga...

Thank you for the feed back on your resolution!  It's a keeper...