Hi

Does any one know how i could use this to change a column name from 'L0O24S1_TEXT' to L0O24S1_TEXT. I have tryed this in SQL Server 2000 Query Analyser:
EXEC sp_rename 'schem_ID_3.'L0O24S3_TEXT'', 'L0O24S3_TEXT', 'COLUMN'

but got the following error:
Server: Msg 170, Level 15, State 1, Line 2
Line 2: Incorrect syntax near 'L0O24S3_TEXT'.

thanks for any help

Can u specify ur question. What column do u want to change.
Sorry I was not able to understand ur question

sorry about that

The table is called:
schem_ID_3

The column i want to change is currently called:
'L0O24S3_TEXT'

and i want to change it to:
L0O24S3_TEXT

Try
EXEC sp_rename 'schem_ID_3.''L0O24S3_TEXT''', 'L0O24S3_TEXT', 'COLUMN'

You need to add a little quotes (') to help MSSQL make the difference between a quote (part of your column name) and a quote (end of string).

HTH

CVM.

Thanks a lot that worked perfectly.
cheers