Operating System - HP-UX
1748089 Members
4978 Online
108758 Solutions
New Discussion

ALLBASE: GROUP BY CAST(..) ?

 
SOLVED
Go to solution
Werner Ittner
Occasional Advisor

ALLBASE: GROUP BY CAST(..) ?

Does anybody know if this syntax is allowed in ALLBASE :

SELECT ..
FROM ..
WHERE ..
GROUP BY CAST(Variable, INTEGER);

Thanks

Werner
1 REPLY 1
Sanjay Kumar Suri
Honored Contributor
Solution

Re: ALLBASE: GROUP BY CAST(..) ?

It is not allowed.

Cast is a Single-Row conversion function. It can't be used in GROUP BY clause.

Thanks.

A rigid mind is very sure, but often wrong. A flexible mind is generally unsure, but often right.