>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

A question would be in which language:) In T-SQL:

SELECT 
  zipcode+
  right('000'+CAST(datePart(dd, GETDATE()) AS VARCHAR(3)),3)+
  right('000'+CAST(datePart(ms, GETDATE()) AS VARCHAR(3)),3) 
from myTable

ms part is 3 ms sensitive and using dd in this one I assume you don't need anything unique, just a fixed size, fixed format value.
Cetin