sbrochu
To help others help you, please post your table definition, sample data, required result and the code you have run following the directions contained in the first link in my signature block. For example:
CREATE TABLE #T ([Name] VARCHAR(10), ExeCount INT, Domain VARCHAR(10),
[Last Logon User] VARCHAR(10), [Start Date] DATETIME )
INSERT INTO #T
SELECT 'C03702', 21,'HANOVER','SLE609','2010-09-14 09:09:03.000'