Hi all,

It appears to me everyone went home early today.

I am needing to concat a couple pieces from the current date to a zipcode field to create a pass phrase for a special purpose. My zipcode field is a char(5) so I am wondering if DatePart(dd, GETDATE()) and DatePart(ms, GETDATE()) end up as string values.

What would be the best way to return a string value of those concatenated to a 5 char zipcode?
Thanks
Tim