Thanks so much....

I bit of a brain crap ... or just being a SPAZZ!!

I was testing with

DECLARE @Date varchar(8)

set @Date='Jul 24 2013 8:05AM'

SELECT CONVERT( datetime, @date)

select cast(cast('Jul 24 2013 8:05AM' as date) as datetime)

wondering why I was coming up with 2002-07-24......

BTW While I'm asking stupid questions....

How do I color code my code in replies?

Thanks Again and have a great date