> Thanks Keith.... I was actually just trying to do it in the table itself
> (via Enterprise Manager, or whatever it's called). But that is also
> helpful
> for future reference! : )
>
> -R
>
>
> "Keith Kratochvil" <sqlguy.back2u@comcast.net> wrote in message
> news:uwG$NbAfFHA.3712@TK2MSFTNGP12.phx.gbl...
>> You will need to do some replacements within this sql statement so that
>> it
>> will run within your environment
>>
>> UPDATE YourTable SET YourSmallDateTimeColumn = NULL WHERE ThePrimaryKey =
> x
>>
>>
>>
>>
>> --
>> Keith
>>
>>
>> "r" <r@r.com> wrote in message
> news:uohewPAfFHA.344@TK2MSFTNGP10.phx.gbl...
>> >I have a table that contains a smalldatetime field. One of the records
> had
>> > a date entered into this field, and now I need to remove the date from
> the
>> > field. Whenever I try to just "delete" it (delete key) I get a
>> > message:
>> >
>> > The value you entered is not consistent with the data type or length of
>> > the
>> > column.
>> >
>> > What can I do to just get that date out of there?! Ideally I'd make
>> > the
>> > field NULL.
>> >
>> > HELP!
>> >
>> > Thanks.
>> >
>> > -R
>> >
>> >
>>
>>
>
>

"r" <r@r.com> wrote in message news:uohewPAfFHA.344@TK2MSFTNGP10.phx.gbl...
> I have a table that contains a smalldatetime field. One of the records
had
> a date entered into this field, and now I need to remove the date from the
> field. Whenever I try to just "delete" it (delete key) I get a message:
>
> The value you entered is not consistent with the data type or length of
the
> column.
>
> What can I do to just get that date out of there?! Ideally I'd make the
> field NULL.
>
> HELP!
>
> Thanks.
>
> -R
>
>

"Keith Kratochvil" <sqlguy.back2u@comcast.net> wrote in message
news:uwG$NbAfFHA.3712@TK2MSFTNGP12.phx.gbl...
> You will need to do some replacements within this sql statement so that it
> will run within your environment
>
> UPDATE YourTable SET YourSmallDateTimeColumn = NULL WHERE ThePrimaryKey =
x
>
>
>
>
> --
> Keith
>
>
> "r" <r@r.com> wrote in message
news:uohewPAfFHA.344@TK2MSFTNGP10.phx.gbl...
> >I have a table that contains a smalldatetime field. One of the records
had
> > a date entered into this field, and now I need to remove the date from
the
> > field. Whenever I try to just "delete" it (delete key) I get a message:
> >
> > The value you entered is not consistent with the data type or length of
> > the
> > column.
> >
> > What can I do to just get that date out of there?! Ideally I'd make the
> > field NULL.
> >
> > HELP!
> >
> > Thanks.
> >
> > -R
> >
> >
>
>

"r" <r@r.com> wrote in message news:uohewPAfFHA.344@TK2MSFTNGP10.phx.gbl...
>I have a table that contains a smalldatetime field. One of the records had
> a date entered into this field, and now I need to remove the date from the
> field. Whenever I try to just "delete" it (delete key) I get a message:
>
> The value you entered is not consistent with the data type or length of
> the
> column.
>
> What can I do to just get that date out of there?! Ideally I'd make the
> field NULL.
>
> HELP!
>
> Thanks.
>
> -R
>
>