Posted by Simon Hayes on 09/29/05 17:34

If the only problem is the column data type, and you know the data
itself is already numeric, then you can just alter the column data type
directly:

alter table SomeTable alter column invamt numeric(10,5)

See "CAST and CONVERT" in Books Online for general information about
data type conversion.

Simon

• Next in forum: Re: How to convert from CHAR to Numeric in the table
• Prev in forum: How to convert from CHAR to Numeric in the table
• Thread view: Re: How to convert from CHAR to Numeric in the table

[Reply to this message]