The way numerical values are displayed cannot be controlled
through the choice of data type. It is purely an issue of how the
client displays values. If you want more control over the display,
select character-type values to display. You may need to use
various string functions, but one possibility is to use str(), which
evaluates to a string expression:
select ltrim(str(<your value>,20,2)) as val ...
>Can anyone tell me which data type will give me
>2 digits to the right of the decimal point (including
>The original field is real
>So When I do Select Cast (1379.0 / 1000 as decimal (9,2))
>I get 1.38 which is what I want
>But when I have Select Cast (0.0 / 1000 as decimal (9,2))
>I get .00 which doesn't look good.
>So to what data type I shoud convert ?