"CSharp ( ILM )" <sql_agentman@hotmail.com> wrote in message
news:eMECKcG8DHA.3648@TK2MSFTNGP11.phx.gbl...
> Hello,
>
> when using Query Analyzer to Debug my stored procedure
>
> I get the following error when inputting datetime values
>
> ERROR: Invalid character value for cast specification
>
> How can I assign a date like 1/1/2005 to a Parameter?? without getting
the
> error above
>
> I tried '1/1/2005' or "1/1/2005" or 1-1-2005 or 2/7/2004 6:43:05 PM or
> etc...
> The only thing that works is null, but I don't want null
>
> Thanks for any advice.
>
> Jackie
>
>
>