create table #DateTest
  (col1 varchar(55),
   col2 varchar(255)
   )


insert into #DateTest(col1, col2)
values ('Order1', '05/12/07'),('Order2', '11/5/2008.'),('Order3', 'Some text'),('Order4', 'Sold 5/5/2009'),('Order5', '8/8/08'),('Order6', '7/4/1776')

select col1
	,col2
	,isdate(col2) as DateCheck
from #DateTest


select
	col2
	,case col1
		when 'Order3' then 'BINGO'
		else col1
	end as col1Test
from #DateTest


select
	col1
	,case isdate(col2)
		when 1 then cast(col2 as datetime) 
		else col2
	end as col2test
from #DateTest


drop table #DateTest