[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
Using $anyvariable in the order by clause
- Subject: Using $anyvariable in the order by clause
- From: Jenny Mckeon <MCKEON@SHANDS.UFL.EDU>
- Date: Thu, 13 Jul 2000 18:05:26 -0400
I need to order a report by Department, Month. I'm deriving month from the
the effective date as follows
$Month = subsr(J.effdt, 6,2) .. The order by clause does not appear to accept
anything but a column variable. Is there a way to get around this constraint ?
I need month by month totals within department.
Jenny Mckeon
Shands Healthcare, Info. Svcs.
Application Systems Analyst, Senior
(352) 395-0680, ext. 8-5232
internet:mckeon@shands.ufl.edu