I guess I don't understand why no-one liked Ryan's first solution with the -275 thingy (although I'm not sure it will withstand a Leap Year).  It was very simple and...

You could easily turn this into a stored procedure or perhaps a table function...

--===== Define the input parameters

DECLARE @PropertyIDtoFind INT

DECLARE @MileageLimit DECIMAL(7,2)

    SET @PropertyIDtoFind = 183297

    SET...

Must be a nasty copy'n'paste error... The code doesn't work as posted...

GO must be the only thing on a line...

Every /* must be match with an */...

...

However, I agree...

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.