<div>
Thank you for you prompt response - but addtionally I am getting the following error:<br />
<br />
erver: Msg 156, Level 15, State 1, Line 1<br />
Incorrect syntax near the keyword 'SET'.<br />
Server: Msg 195, Level 15, State 1, Line 1<br />
'DATA' is not a recognized SET statement.<br />
<br />
I tried using modify.<br />
<br />

</div>


Thank you for you prompt response - but addtionally I am getting the following error:

erver: Msg 156, Level 15, State 1, Line 1
Incorrect syntax near the keyword 'SET'.
Server: Msg 195, Level 15, State 1, Line 1
'DATA' is not a recognized SET statement.

I tried using modify.



<div>
ALTER TABLE Course<br />
&nbsp; &nbsp; ALTER COLUMN Course_Name varchar(50) NULL<br />
<br />
I used this - and it worked.<br />
<br />
Thank you.
</div>


ALTER TABLE Course
    ALTER COLUMN Course_Name varchar(50) NULL

I used this - and it worked.

Thank you.

<div>
<div class="content wysiwyg-content">
Hi I am having problems altering or updating a table to hange the num,ber of charatcers a row takes.<br />
<br />
Right Now I have a table name Course<br />
I need to change the Course Name from varchar(15) to (40)<br />
I have tried <br />
ALTER table Course <br />
update course_name varchar(50) &nbsp;but get an error - also tried using the update command.<br />
<br />
Thank you,
</div>
</div>


Hi I am having problems altering or updating a table to hange the num,ber of charatcers a row takes.

Right Now I have a table name Course
I need to change the Course Name from varchar(15) to (40)
I have tried 
ALTER table Course 
update course_name varchar(50)  but get an error - also tried using the update command.

Thank you,

SQL 2000

Programming includes both the specifics of the language you’re using, like Visual Basic, .NET, Java and others, but also the best practices in user experience and interfaces and the management of projects, version control and development. Other programming topics are related to web and cloud development and system and hardware programming.