Hello James

I have no idea about sql server

but have you tried

ctod('01/01/2002')

>Hello group,
>
>I have a procedure:
>
>CREATE PROCEDURE sp_create_translator
>@SchoolYear smalldatetime
>AS
>How do I exec this from the sql server query analyzer. Exec '01/01/2002' doesn't work or {01/01/2002 }either.
>
>Thanks
>Jim