>>>> >>>> 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 ? >>>>>>>
>>>where MyDateTimeColumn >='20121002000000' >>>>>Thanks Greg but it didn't work "Conversion failed when converting datetime to character string"
>where MyDateTimeColumn >='20121002 00:00:00" >Worth knowing - thanks again