Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[tunnie]

Does anyone know how to format a colum with SQL to remove a decimal point and reformat it to a numerical column rather than character?

[Andy B]

Does anyone else understand the question?  :-/      

[Phil B]

Yep. Just looking through me scripts

[Phil B]

What data type is the column now?

[Phil B]

If it's already a text column, use
update dbo.table
set column2 = replace(column2,'.','')

replaces the . with nothing, then change the datatype in manager to a numeric one? Just tried it on a test table seemed to work ok

[cem_devecioglu]

if for display,print purpose

select convert(decimal(25,0),field) from table

or

select cast(field as decimal) from table

this will cut the fraction part and still keep the numeric representation


or if you want to modify the column you must use

alter table TABLE alter column COLUMN  decimal(25,0) NOT NULL etc