dropping a decimal from a field in TSQL

[MACTONI]

I have a column in my table name feeamount. I have numbers like 0.809, 0.734 and even 0.752.

What tsql statement do I run to remove the their decimal place so my number will appear in the table as 0.80, 0.73 and 0.75. In other works drop the third place.

THANKS FOR YOU HELP

 

[dhookom]

Do you want to actually "drop" the precision or make it "appear" as if it is 2 decimal places. You have used both words in your question. Typically this should be asked in the SQL Server Programming forum.

Duane
Hook'D on Access
MS Access MVP

 

[SkipVought]

Basically you would
[tt]
Integer([your column]]*100)/100
[/tt]
however it is expressed in your SQL.

In Access...
[tt]
INT([your column]]*100)/100
[/tt]


Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[MACTONI]

I actually want to drop the third place.

For example all number appear as .xxx would appear as .xx

 

[SkipVought]

That is what the formula does: truncates to 2 decimal places.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[dhookom]

To actually update the data in the field, you should use an update query.

Duane
Hook'D on Access
MS Access MVP

 

[Andrzejek]

I have numbers like 0.809 [...] as 0.80

You may want to Round the number so you would get 0.81 (and not just 0.8), but you may not care about it. Depends on your requirements.

Have fun.

---- Andy