Posted by Mike on 10/13/05 18:50

Ok I have another problem with some of the data. I did not notice this but
some of the columns where nvarchar data types and the math is not working on
them. I tried to change the data type to decimal but Enterprise Manager is
giving me and error saying it can not convert the data type.

The table I am working was imported and the data types were nvarchar but I
managed to change them to varchar data types but I need them to be numeric
or decimal data types so that the math will work.

Can any one tell how to change these?

Thanks!

"Mike" <noway@forgetit.com> wrote in message
news:5Mt3f.9$Ej6.4@newssvr17.news.prodigy.com...
> Thanks!! That did the trick!!
>
> "David Portas" <REMOVE_BEFORE_REPLYING_dportas@acm.org> wrote in message
> news:1129210392.828258.210620@g44g2000cwa.googlegroups.com...
>> INSERT INTO Cost_Percent (svccode, price, dwages, dmatls)
>> SELECT svccode, price, dwages/price, dmatls
>> FROM xfile
>> WHERE ... ?
>>
>> --
>> David Portas
>> SQL Server MVP
>> --
>>
>
>

[Back to original message]