Changing Column Name

Is there a way to change a column name in one of the tables? Say from XX to
YY. What's the syntax for that?
--
TSTS, try:
EXEC sp_rename 'tablename.[oldcolname]', 'newcolname', 'COLUMN'
BG, SQL Server MVP
www.SolidQualityLearning.com
Join us for the SQL Server 2005 launch at the SQL W in Israel!
[url]http://www.microsoft.com/israel/sql/sqlw/default.mspx[/url]
"TS" <TS@.discussions.microsoft.com> wrote in message
news:E666BE78-43C2-4396-9B88-E92054D70B8C@.microsoft.com...
> Is there a way to change a column name in one of the tables? Say from XX
> to
> YY. What's the syntax for that?
> --
> TS