>> >> Select * >>from mytable >>where convert(varchar,MyDateTimeColumn,3) >= '01/10/12' but I'm still getting records with a date prior to that e.g I get records back with '23/07/12' - any ideas ? >>>
>-- Is not affected by SET DATEFORMAT >where MyDateTimeColumn >= '2012-10-01' >Thanks Sergey