Change Column name with ALTER statement

Hi,
Quick question.
How do I change a column name with the ALTER TABLE statement without losing
the data?
Thanks
ChristianCheck out sp_rename in BooksOnLine
Andrew J. Kelly SQL MVP
"Christian Perthen" <abracadabara@.dontreplytothidress.com> wrote in
message news:ew3DT27CFHA.3728@.TK2MSFTNGP14.phx.gbl...
> Hi,
> Quick question.
> How do I change a column name with the ALTER TABLE statement without
> losing
> the data?
> Thanks
> Christian
>|||Sorry,
I found the answer, sp_rename
Thanks anyway.
CHR
"Christian Perthen" <abracadabara@.dontreplytothidress.com> wrote in
message news:ew3DT27CFHA.3728@.TK2MSFTNGP14.phx.gbl...
> Hi,
> Quick question.
> How do I change a column name with the ALTER TABLE statement without
losing
> the data?
> Thanks
> Christian
>