Multiply

[Steve95]

Hi All

I am trying to multiply the following

select process_yr
from tbl_report
where (process_yr*4)

and its not working....some can some one tell me what Iam doing wrong...

Many Thanks

 

[ptheriault]

Are you look for all the values from the table where the process year is equal to process year * 4 or are you trying to select the process year * 4?




- Paul

- If at first you don't succeed, find out if the loser gets anything.

 

[Steve95]

Iam trying to select the process year, year and then 3 column as process * 4

Any ideas?

 

[monksnake]

select process_yr * 4
from tbl_report


<.