>>Try
>>
>>SELECT CONVERT(CHAR(8),Hit.AddDate,112) + CONVERT(CHAR(2), Hit.AddDate,108)
>>
>>BTW, in SSMS highlight CONVERT and Press F1. It will give you all formats available for CONVERT.
>
>Thanks, this simplifies things up.
You're welcome.
If it's not broken, fix it until it is.
My Blog 
