seql 2000 Query returns wrong results

Hi all
Convert(decimal(10,1),(taxid*10)/100) as tax

value in taxid is 1. And also im getting .0 result but it should return
.1
Plz help me..........why im getting wrong answer.

Junior Poster in Training

88 posts since Dec 2008

Reputation Points: 10

Solved Threads: 2

CHANGE YOUR CODE IN THE BELOW WAY:

Convert(decimal(10,1),(taxid*10.00)/100.00) as tax

Posting Whiz in Training

247 posts since Apr 2009

Reputation Points: 26

Solved Threads: 44

wow that really works.
Thank u mail2saion

Junior Poster in Training

88 posts since Dec 2008

Reputation Points: 10

Solved Threads: 2

This question has already been solved

You