String Manipulation

[Dutt]

I have a table called table1. It has a column called column1 and the datatype is numberic.

Each record in that column has a trailing ".00000". I'm trying to build an update statment that will trim off the .00000.

Any help would be great!

Justin

 

[JamesLean]

If the data type is numeric, you won't be able to get the data stored without the specified number of decimal places. You would need to actually change the data type of the column to do that.

If you want the data displayed without the DPs then use:

SELECT CONVERT(int, col1) FROM t1

--James

 

[ClaireHCM]

Try this
select convert(decimal(7,0),colname) from table

 

[Dutt]

I get the error when I try both examples:

Arithmetic overflow error converting numeric to data type numeric.
The statement has been terminated.


Is there a way to do it in a Update Statement?

Cheers,
Justin

 

[ClaireHCM]

Try this

select convert(decimal(25,0),@i)

 

[SQLBill]

Check your data.

Do you have NULLs?
Do you have empty data fields (spaces)?
Do you have any characters that are not numbers?

Any of those can cause the convert to fail.

-SQLBill