Hi Micheal

That helped.

Thanks
Jim
>FYI - SQL Server will interpret date literals based on the way that SET DATEFORMAT is set. However, the form YYYYMMDD is insensitive to DATEFORMAT.
>
>EXECUTE sp_create_translator '20020516'
>
>-Mike