Just a bit of an exercise to show what can be done, and some of the possible issues if the date format isn't always the same
declare @tbl table
(txtstr varchar(50)
)
insert into @tbl
select ' 02-28-2017, 04:03 PM asb' as str
-- 12345678901234567890
union
select ' 12-28-2017, 04:03 PM asb' as str
-- 12345678901234567890
union
select '28-12-2017, 04:03 PM asb' as str
-- -- 12345678901234567890
union
select ' 2-28-2017, 04:03 PM asb' as str
-- -- 12345678901234567890
union
select ' 02/1/2017, 4:03 PM asb' as str
-- -- 12345678901234567890
where does 'asb' in your string come from
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day