Posted by David Portas on 10/07/05 00:41

ALTER TABLE table_name ALTER COLUMN col_name VARCHAR(10) ;

--
David Portas
SQL Server MVP
--

"Nothing" <me@you.com> wrote in message
news:1Je1f.13$vU5.1288@news.uswest.net...
>I received a db2 data file that I converted to MS-Access. From Access I
> ran the upsize wizard to put the tabel in SQL. It put the table in ok
> but all the data types are nvarchar. I have a couple of the fields that
> are cureny and some that are numeric.
>
> I need to change the data types from nvarchar to numeric type fields. I
> am new to SQL so I do not know all the commands. How do I change the
> data type?
>
> Michael Charney
>
> *** Sent via Developersdex http://www.developersdex.com ***

[Back to original message]