TRY_CONVERT() is also useful for check constraints. For example, below we are requiring that "date" values stored in a VarChar column called FooDate can be casted as an actual Date.
create table #mytest
FooDate varchar(20) not null
constraint cc_FooDate check ( try_convert(date, FooDate) is not null )
insert #mytest ( FooDate) values ('2016/02/28');
(1 row(s) affected)
insert #mytest ( FooDate) values ('2016/02/30');
The INSERT statement conflicted with the CHECK constraint "cc_FooDate".
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho