thanks I found it in MSDN 


 --- David Cameron <dcameron@i...> wrote: >
ALTER TABLE <your table> ALTER COLUMN <your column>
> int
> 
> regards
> David Cameron
> 
> 
> -----Original Message-----
> From: Himanshu Chaudhari
> [mailto:himanshuchaudhari@y...]
> Sent: Thursday, 23 August 2001 2:43 PM
> To: sql language
> Subject: [sql_language] changing col from nvchar to
> numeric
> 
> 
> I want to change a column in my database from nvchar
> to numeric . what type of query has to write if I
> want
> to do it online. The records in the column are all
> numeric.
> 
> 
> 
>          Himanshu