Changing a column datatype

[ShaliniJennifer]

Hi,

I had to change a columns datatype from money to varchar(100)...I have data in my table..I am using sql-server 2005..I tried the following coding..

ALTER TABLE bb
ALTER COLUMN dealercost varchar(100) NOT NULL

It gives me an error as:

Msg 260, Level 16, State 1, Line 1
Disallowed implicit conversion from data type money to data type varchar, table 'ACIG01_DSV.dbo.bb', column 'DealerCost'. Use the CONVERT function to run this query.


Plz Help..

Thanks in advance

[deepuv04]

Hi,

I had to change a columns datatype from money to varchar(100)...I have data in my table..I am using sql-server 2005..I tried the following coding..

ALTER TABLE bb
ALTER COLUMN dealercost varchar(100) NOT NULL

It gives me an error as:

Msg 260, Level 16, State 1, Line 1
Disallowed implicit conversion from data type money to data type varchar, table 'ACIG01_DSV.dbo.bb', column 'DealerCost'. Use the CONVERT function to run this query.


Plz Help..

Thanks in advance

try without not null in your query


ALTER TABLE bb
ALTER COLUMN dealercost varchar(100)


thanks

[ShaliniJennifer]

try without not null in your query


ALTER TABLE bb
ALTER COLUMN dealercost varchar(100)


thanks

Tried without using not null in my query

and still got the same error

[debasisdas]

Try to use alter the table .
Please find the syntax here .