show data only which DB dates are greater than Todays date

declare @tbl table

(policyno int,

PolicyEndDate varchar(20)

) insert into @tbl

select 567,'10-08-2017'

union all

select 9087,'09-08-2017'

union all

select 1567,'10-08-2017'

union all

select 5643,'09-08-2019'

union all

select 7854,'09-07-2017'

select policyno,PolicyEndDate from @tbl --return all record due to conversion of PolicyEndDate in date and converts into yyyy-mm-dd

where cast(PolicyEndDate as date)>=convert(varchar(10),getdate(),105)

select policyno,PolicyEndDate,cast(PolicyEndDate as date) from @tbl --retruns only 2 rows as getdate() is converted to string and returns only equal data.(no greater/less then)

where PolicyEndDate>=convert(varchar(10),getdate(),105)