Perfect! Thank you so much. My SQL skills have just gotten better Cheers.

Now I Get this:

Msg 245, Level 16, State 1, Line 2

Conversion failed when converting the nvarchar value '11/13/1964' to data type int.

SELECT

dimUser.EmpFullName1 [User Name],

dimUser.MgrEmpFullName1 AS Manager,

dimUser.PrimaryJobName AS [Primary Job],...

The vendor will not give us access to the live data....

The filed has multiple dates in it. The 20050307 was just an example. Now all the dates say 2005-03-07???