>Dear Experts,
>
>How to set date in Brit format in SQL server.
>
>Presently it shows as '02/14/2006' and i want set as '14/02/2006' permenently,
>how i will do this.
>
>thanks in advance
>
>Abdulla

SQL server uses control panel settings. But would that matter anyway? You actually want to show it in VFP, right? Set date to DMY.
Cetin