>George,
>thanks but when I run this statement it also returns the same erro message as it returned for Sergey.
>"The conversion of char data type to smalldetime data type resulted in an out-of-range smalldatetime value"
>It seems to me that it's necessary remove the slash "/" from the date to make it work.
It may be that you've indicated that the date seperator is a hyphen (-) rather than a slash in the SQL Server options.
George
Ubi caritas et amor, deus ibi est