Try:

ALTER TABLE LoginLevels
ALTER COLUMN UserName varchar(25)



-----Original Message-----
From: Dean [mailto:spinout@i...]
Sent: Wednesday, January 16, 2002 10:02 AM
To: sql language
Subject: [sql_language] RE: Alter Table - changing columns from char to
varchar


Nup it still doesn't work. I am now using:

ALTER TABLE LoginLevels
(
	ALTER COLUMN UserName varchar(25),
	ALTER COLUMN AccessAreas varchar(25)
)


and I get the error:

Msg 170, Level 15, State 1, Server PLUNGER53, Line 2 
Line 2: Incorrect syntax near '('. 


*confused*

> Instead of MODIFY COLUMN
> Use ALTER COLUMN
> 
> And I don't think you need the second comma

$subst('Email.Unsub').


This electronic message transmission, including any attachments, contains information from PacifiCare Health Systems Inc. which may
be confidential or privileged. The information is intended to be for the use of the individual or entity named above. If you are not
the intended recipient, be aware that any disclosure, copying, distribution or use of the contents of this information is
prohibited.  

If you have received this electronic transmission in error, please notify the sender immediately by a "reply to sender only" message
and destroy all electronic and hard copies of the communication, including attachments.