Try this:
declare @testdate varchar(50), @realdate datetime
set @testdate = 'Monday, January 28, 2008'
set @realdate = SUBSTRING(@testdate, CharIndex(', ', @testdate)+2, 50)
select @testdate, @realdate
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes