hi,
If you have VARCHAR data type for input column, you can do as follows,
--Sample Data Generation
declare @tab table( dates varchaR(100))
insert @tab
SELECT '26.09.14' union all
SELECT '27.09.14' union all
SELECT '02.01.2015' union all
SELECT '25.02.2015' union all
SELECT '27.10.2015'
-- Query to be used
SELECT *, cast(dates as datetime) FROM @tab
where cast(dates as datetime) >= cast(getdate() as date)
Mark This Response as Answer
--
Chandu
http://www.dotnetfunda.com/images/dnfmvp.gif
Raja_89, if this helps please login to Mark As Answer. | Alert Moderator