Re: Decimal Alias values return as zero?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Then use the convert (or cast) function to convert your integer fields to
float or real types.

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)


"Jay" <spam@xxxxxxxxxxxxxxxxxxxxx> wrote in message
news:O4iheXILIHA.3848@xxxxxxxxxxxxxxxxxxxxxxx
Thanks for the suggestion, but I can't add a decimal point to any of the
two field being used in the calculation because these are fields on the
sql server which I can only refer to by field name.

Thanks......Jason


Sylvain Lafontaine wrote:
Add a decimal point to at least one operand:

Select (500 / 700), (500 / 700.0)



.

Relevant Pages