Re: Manipulating Aggregate Function Values

[Juan Alvarado <juan@GYSSA.COM.GT>]

Only you need to store in a column variable and use in the code of SQR
For example

begin-select
count &conteo
        print &conteo (+1,1)
        let #resp = &conteo * 1.25
from sysobjects
end-select

I hope this help you

Juan Manuel Alvarado
CPS-DBA Sybase XI
Gerencia & Sistemas Guatemala
www.gyssa.com.gt

> -----Original Message-----
> From: Bergeron, Marc, Herndon [SMTP:BergeronM@ALPA.ORG]
> Sent: Tuesday, August 25, 1998 2:43 PM
> To:   Multiple recipients of list SQR-USERS
> Subject:      Manipulating Aggregate Function Values
>
> It's great to be able to use Aggregate functions (MAX, SUM,
> COUNT(*).....) in SQR but how does one multiply the resulting SUM() by
> -1 or PRINT COUNT(*).