I have a database I'm building for several Departments. The data includes personal information for people that attend events my company puts on throughout the year. We also have a commercial Database for Members. The events include both members and non-members. I'm trying to create a field called personkey that will be used to link our custom Database to the Members in the commercial Database. I've created a field that takes the first 4 characters of the lastname, the first 4 of the firstname and the DOB in the format mmddyyyy to create that field. The data is in SQL Server 2008 R2. I want to create a view that included the primary key field of the commercial members table and builds the personkey from the commercial members table so I can link from our database to the commercial members database. Just not sure how I can convert the Birth date field to the mmddyyyy string I need to complete the personkey field. Looked at Cast but it doesn't allow you to put in a specific format as far as I can tell. Anybody have an idea how I can complete this?