>Thanks very much, Viv.
>
>Setting date Brit has sorted the problem out !
>
>Thanks again,
>
>Regards,
>
>Steve.
If you don't want the result to depend of SET DATE setiings use DATE() function to get valid date value:
? DATE(2006,1,1)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.