>You'll have to convert them to a string
>
>zipcode + RIGHT('00000' + CAST(DATEPART(dd, GETDATE()) * 1000 + DATEPART(ms, GETDATE()) AS varchar(5)),5)
>
>>
>>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?
Thank You Sergey, also what I need. Between these answers I can get everything I need.
Tim
Timothy Bryan