select substring(cast(settledate as varchar(10)),6,2)+ '/'+ substring(cast(settledate as varchar(10)),4,2)+ '/' + substring(cast(settledate as varchar(10)),1,4)as SettleDate from table1

Hope this shold work.

Thanks,

Hanu